Replace Field in Table A with value from Field in Table B

[chriys1337]

Hi,

I am trying to replace some values in the Table A, in case the value in Table A is "UNKOWN".

In this case I would like to use the Field from Table B.

Does anybody have an idea, how to archive this?

Thanks!!

Chris

[sunny_talwar · Accepted solution]

Check my response here:

Left Join where field is like "x"

[prieper]

I would suggest to use the MAPPING functionality:

mapUnknown: MAPPING LOAD Key, MyField RESIDENT TableB;

TableA:

LOAD *,

IF (MyField = 'UNKNOWN', APPLYMAP('mapUnknown', MyField))          AS MyField_updated

FROM .....

Peter