Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I think it should be
....where not exists(NRowID,RowID)
Existing field to check always comes first.
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;