topic Applymap on the same field Multiple Times in QlikView

Applymap on the same field Multiple Times

Anonymous — Tue, 16 Jun 2015 20:07:50 GMT

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

Re: Applymap on the same field Multiple Times

marcus_sommer — Tue, 16 Jun 2015 20:10:34 GMT

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

- Marcus

Re: Applymap on the same field Multiple Times

Clever_Anjos — Tue, 16 Jun 2015 20:28:55 GMT

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,