Compare multiple columns

[Anonymous]

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

[#2]

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

[sunny_talwar · Accepted solution]

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;

[Anonymous]

Hi Sunny,

seems to work, many thanks.

Regards,

Sam