Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
at 1st i load this data. Tablename: tableA
After that i load this table tableB. In the load script i want to add the column Found...
...and want to compare the columns Product, SalesNumber, Customer of each record with data from tableA.
If the value of each column identical, then Found should get the value "x".
How can i do it?
Regards,
sam
May be this:
TableA:
LOAD *,
AutoNumber(Product&SalesNumber&Customer) as Check;
LOAD Date,
Product,
SalesNumber,
Customer
FROM TableA;
TableB:
LOAD Date,
Product,
SalesNumber,
Customer,
If(Exists(Check, AutoNumber(Product&SalesNumber&Customer)), 'x') as Found
FROM TableB;
DROP TableA;
Hi,
We can use Apply map function if it has a unique column, I'm looking forward to the answer how it is done without a unique column,
Regards,
prem
May be this:
TableA:
LOAD *,
AutoNumber(Product&SalesNumber&Customer) as Check;
LOAD Date,
Product,
SalesNumber,
Customer
FROM TableA;
TableB:
LOAD Date,
Product,
SalesNumber,
Customer,
If(Exists(Check, AutoNumber(Product&SalesNumber&Customer)), 'x') as Found
FROM TableB;
DROP TableA;
Hi Sunny,
seems to work, many thanks.
Regards,
Sam