mapping table

[#1]

Hi All,

I have a mapping table that I would like to map some values (which are in another table) to. Any suggestions on the best way?

Thank you Herbert

[daveamz · Accepted solution]

Hi,

MapTable:

Mapping

Load Value,

        Map To Value

from Mapping Table2.xlsx ...

LOAD *, ApplyMap('MapTable, Value) as MappedValue

....

Regards,

David

[#3]

hi

you can try

ValueMap:

mapping load

Value,

MapValue

From  XXX;

then on the Main table for the field.

Data:

Load

value,

ApplyMap('ValueMap',Value) as MapValue

From XXX2

or resident  XXXX2

thanks

Michael

[#4]

Thank you

[#5]

cool anytime...