How to subset data based on a condition in the script editor?

[#1]

Hi,

I have table1 with some columns, I want to create another table, table2 which has only those rows in which column1 = 'x'(sub-setting) , for example.

How can I do this using qlik sense data load editor?

Thanks,

Srijhari

[#2]

I think you can use where, example below:

table1:

load a,

          b,

          c,

          d

from source where a<>'teste';

table2:

load a as 1,

          b as 2,

          c as 3,

          d as 4

from source where a='teste';

or

table1:

load a,

          b,

          c,

          d

from source;

table2:

load a as 1,

          b as 2,

          c as 3,

          d as 4

residente table1 where a='teste';

[#3]

Thank you so much!

[#4]

good...mark witch corretc repost if as halpful for community stay organized