Discussion Board for collaboration related to QlikView App Development.
I have a code like :
Load * from Dim.qvd
123 as key,
'abc' as name
So in this case will the concatenate happen before the keep or after the keep, in case concat happens after the keep, how do i ensure that concat happens before the keep operation without loading the tables again.
@Vegar , @kaushiknsolanki
The script is executed line by line, so in your case, the Left Keep will be done and then the concatenation.
well then i will need to perform a right keep and load the fact again right ...so that concat happens prior to keep
So is there a better way to do this rather loading the fact again
I'm not really following you why you want the concat to happen in prior to the keep. If the keep affected by only one field (I assume the field key) you could skip the keep and use exists instead.
Like this:Dim:123 as key,'abc' as nameautogenerate (1);concatenate (Dim)Load * from Dim.qvdWhere exists (key);