Join one field depending on two

[Hatus]

Hello everebody,

I'm trying to connect two tables but I can't find a way to do this. The second table has IDs from old and new Databases, to consult the new ID from the old database with the description an vice versa the field Serials musst be joined only if it machtes the Serial_A or Serial_B.

They look like this:

List_Table:

Serials description

10 a

20 b

9030 c

9010 d

Mixed_IDs_Table:

Serial_A Serial_B

10 0010

1109 9030

20 0032

9010 3301

I need to join the description field on the Mixed_IDs_Table with the correct fields. At the end the Final_Table should look like this

SERIAL_A SERIAL_B DESCRIPTION

10 0010 a

1109 9030 c

20 0032 b

9010 3301 d

I appreciate your help kindly.

Regards

Hatus

[renjithpl]

HI

In your edit script use below code;

LOAD Serial_A as Serials,

SerialB

FROM

abctest.xlsx

regards

[Hatus]

Hello

Thanks for your answer, but how do you join the description field on the correct serials?

Regards