Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi this mahesh new to qlikview i had loaded table from from excel like this
Old:
LOAD country,
date,
price,
productid,
source
FROM
(biff, embedded labels, table is Sheet1$) ;
i want use filter condition and want to derive new table
can i write like this from resident after re loading i am unable to see New table. how to get New table
New:
load * resident old where source='online' and country='ind'
please correct if my script is wrong thanking you in advance
Two tables that have exactly the same columns will automatically concatenate. As a result the new table will never exists and the rows will just be added to the old table.
Two solutions:
If you do not want two tables, but only want to filter, just add the where clause to the initial load:
Old:
LOAD country,
date,
price,
productid,
source
FROM
(biff, embedded labels, table is Sheet1$)
where source='online' and country='ind';
Alternatively, you can add the noconcatenate statement to the 2nd load:
New:
noconcatenate
load * resident old where source='online' and country='ind';
Keep in mind that when two tables have more then 1 column in common you get a synthetic key; not what you want.
Two tables that have exactly the same columns will automatically concatenate. As a result the new table will never exists and the rows will just be added to the old table.
Two solutions:
If you do not want two tables, but only want to filter, just add the where clause to the initial load:
Old:
LOAD country,
date,
price,
productid,
source
FROM
(biff, embedded labels, table is Sheet1$)
where source='online' and country='ind';
Alternatively, you can add the noconcatenate statement to the 2nd load:
New:
noconcatenate
load * resident old where source='online' and country='ind';
Keep in mind that when two tables have more then 1 column in common you get a synthetic key; not what you want.
Hii okg
Thanks so much