Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Can we put some conditions while writing storing a table into QVD or any other alternative to the same.
Regards
Kushal Thakral
see if you have same column names then it wil automatically concatenate with the previous table.
so try like this , either use NoConcatenate key word before the new table or rename all the field of new table .
A:
LOAD A,
flag
from A;
NoConcatenate
B:
LOAD A,
flag
resident A
where flag=0;
what condition you want to write?can yu breif little more
Hi Kushal,
While storing in the sense, we can use where conditions and other filter conditions in script. We can store that table in QVD. Hope you got it. Thank you.
Hi
Conditions like where like what we write in case of Loading a table same can we apply while writing Store.
Regards
Kushal Thakral
Hi Arjun
i need to store it in Qlikview
Regards
Kushal
you cannot write thos in store command i hope
then any alternative to the same
With the STORE key word we cannot write any where condition, whiling building the table only you need to specify the same
what is the scenario ?
you can write the where in load statement for which you are creating qvd
Scenario is like i have records in table with flag field containing 0 and 1 but while storing it into QVD i need only those having Flag 0
Regards
Kushal