
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Keep followed by Concatenate
Hi,
I have a code like :
Left keep(Fact)
Dim:
Load * from Dim.qvd
concatenate
123 as key,
'abc' as name
autogenerate (1)
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The script is executed line by line, so in your case, the Left Keep will be done and then the concatenation.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 name
autogenerate (1);
concatenate (Dim)
Load * from Dim.qvd
Where exists (key);
Qlik Community MVP
