topic Re: Concatenation Where Not Exists - Issue in QlikView

Concatenation Where Not Exists - Issue

haymarketpaul — Wed, 08 Jul 2015 09:45:54 GMT

I have a table with the following sort of data...

Pot 1

I want to concatenate another data pot to that with the following in it

Pot 2

Here's the issue - if the U:xxxxx in pot 2 already exists in a row in pot 1 then i do NOT want to append that row.

So in the example above only the 2nd row from pot 2 would get appended to pot 1

Any ideas how best to achieve this much appreciated.

Anonymous — Wed, 08 Jul 2015 09:52:07 GMT

you Need to prepare an additional field

load

RowID,

left(RowID,6) as NRowID

from

concatenate load

RowID

from

where not exists(RowID,NRowID)

if you provide example the correct Syntax can be provided

swuehl — Wed, 08 Jul 2015 09:58:43 GMT

I think it should be

....where not exists(NRowID,RowID)

Existing field to check always comes first.

Wed, 08 Jul 2015 10:04:36 GMT

pot1:

load *, left(row,7) as seprow Inline

[

row

U:12345C:54321

U:67890C:73996

U:13579C:83745

];

Concatenate(pot1)

load rowid as row

resident pot2

Where not Exists(seprow,rowid);

EXIT Script;