topic Re: Double Apply Map in QlikView

Double Apply Map

Wed, 25 Nov 2020 16:16:04 GMT

Good day

I have my mapping load table with all the mapping detail that is required for a applymap.

But now I want to apply the map to different fields in different tables.

Only doing the apply map once in order to get one field to use in the front end.

Is this possible?

JuiceName
Juice Table:

SoftDrinkName
SoftDrink Table:

MappingDrinks	DrinkName
Coke	SDCoke
Sprite	SDSprite
Fanta	SDFanta
Orange	JuiceOrange
Mango	JuiceMango
Apple	JuiceApple

I tried

applymap('MappingDrinks',SoftDrinkName, JuiceName) as Drinks

Thanks in advance

Re: Double Apply Map

miguelbraga — Mon, 12 Sep 2016 15:26:26 GMT

Hey there,

I'm affarid to dissapoint you, but you can't make a double applymap. Lete me ask you this question because I didn't understood your issue: What you are trying to achieve? Please explain us better

Regards,

Re: Double Apply Map

marcus_malinow — Mon, 12 Sep 2016 15:28:12 GMT

Corleen,

so, if I understand you correctly you have done a single MAPPING LOAD.

Given that you are loading two tables, one for Juices, and one for SoftDrinks, you will need to do two applymaps, using the same mapping table. These will be:

applymap('MappingDrinks', JuiceName) as Drinks

and

applymap('MappingDrinks', SoftDrinkName) as Drinks

You will then end up with a common field named Drinks.

I'm not sure what the structure of your data model is, so this may cause linking issues.

Marcus

Re: Double Apply Map

sunny_talwar — Mon, 12 Sep 2016 15:37:49 GMT

Can you elaborate on what you are trying to do? I am not sure I understand what you are trying to do . Would you be able to provide a sample

Re: Double Apply Map

Anil_Babu_Samineni — Mon, 12 Sep 2016 15:45:04 GMT

What is the expected o/p using Apply Map?

Re: Double Apply Map

stigchel — Mon, 12 Sep 2016 16:32:02 GMT

It looks like you want to combine two fields from different tables? You can Resident load form these tables to create a new field Drinks. I'm not even sure you would need a map, I would also create a field say SortOfDrink. This looks like this:

Script something like this:

JuiceTable:

Load * Inline [JuiceName

Orange

Mango

Apple

];

SoftDrinkTable:

Load * Inline [SoftDrinkName

Coke

Sprite

Fanta

];

Drinks:

load

'Juice' as SortOfDrink,

JuiceName as [Drinks]

Resident JuiceTable;

//This concatenates to the table above

load

'Soft Drink' as SortOfDrink,

SoftDrinkName as [Drinks]

Resident SoftDrinkTable;

//If not needed anymore, dropping the original tables

Drop Table JuiceTable;

Drop Table SoftDrinkTable;

Re: Double Apply Map

santiago_respane — Mon, 12 Sep 2016 17:24:00 GMT

Hi,

you would be able to do it if both fields where in the same table. But with your structure as it is you wont be able to map both fields.

The syntax should be something like this:

applymap('MappingDrinks',SoftDrinkName, applymap('MappingDrinks',JuiceName,'No map value')) as Drinks

It would be great if you share a sample app in order for us to give you a more accurate answer, otherwise we are just guessing here.

Please let me know if this helps.

Kind regards,