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?
I think you can use where, example below:
from source where a<>'teste';
load a as 1,
b as 2,
c as 3,
d as 4
from source where a='teste';
residente table1 where a='teste';
Thank you so much!
good...mark witch corretc repost if as halpful for community stay organized
Retrieving data ...