Concatenation Where Not Exists - Issue

[haymarketpaul]

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

Pot 1

RowID
U:12345C:54321
U:67890C:73996
U:13579C:83745

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

Pot 2

RowID
U:12345
U:52436
U:13579

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]

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]

I think it should be

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

Existing field to check always comes first.

[#4]

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;