LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: what_to_do

Hi All,

I'm very new to lavastorm and would like to seek your guidance. I am trying to filter all distinct rows within a table. In SQL one is able to use SELECT DISTINCT * and it returns all unique rows across all columns. Is there a way of doing this in Lavastorm?
Attachments:
Distinct Trial of Nmdump31.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Hello,

If you are trying to do select distinct records from a database table using LAE, the operation is essentially the same, you just do it using a specific node.

There is a node, "DB Execute", which allows you to specify the particular 'select' statement you want. It is in the CORE library, under the Database section. See your Node Help file when you locate it.

DB Execute uses 2 special BRAINScript commands to define what kind of operation it is doing: sqlSelect, and sqlNonSelect. sqlSelect is used for querys, sqlNonSelect for any other type of operation. Both of these can be found in your BRAINScript help.

When you open the node to edit it, in the script area do the following:

sqlSelect(1, "select DISTINCT from.....<the rest>")

That should do what you want.

Regards
Timon Koufopoulos
MDA Support.