Applymap on the same field Multiple Times

[Anonymous]

Is there a limit to which how many times I can do an applymap on the same field.

For eg. I have main table

Main:

ID,

Name,

Order date,

Attribute1

Vendor:

ID,

Vendor_Name

Dept:

ID,

Dept_Name

Inv:

ID,

qty

so if I create mapping table for 3 diff tables and applymap on the same table 'Main' 3 times to 'map' on the same field, i.e. ID, will it work.? I know a better way wud be to let the tables have automatic connection as they have coomon field "ID". but just wanted to get your ideas.

Thanks

[marcus_sommer]

Yes it's possible - you should give them simply a try.

- Marcus

[Clever_Anjos · Accepted solution]

Yes, you can applymap how many times you need, with different maps

load

ApplyMap('map1',field) as dept,

ApplyMap('map2',field) as company,

ApplyMap('map3',field) as field3,

ApplyMap('map4',field) as field4,