Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

3 Replies
Not applicable

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

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';

Not applicable

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

Thank you so much!

Not applicable

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

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

Community Browser