Keep followed by Concatenate

[anushree1]

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 

[kaushiknsolanki]

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

[anushree1]

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]

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