Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

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.

@Vegar , @kaushiknsolanki 

3 Replies
kaushiknsolanki

The script is executed line by line, so in your case, the Left Keep will be done and then the concatenation.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
anushree1
Specialist II
Specialist II
Author

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

Vegar
MVP
MVP

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);


Plees ekskuse my Swenglish and or Norweglish spelling misstakes