topic Re: Map Using - where do I apply this? in QlikView

Map Using - where do I apply this?

Tue, 24 May 2016 12:44:09 GMT

Hi All

Please forgive me for what is (I am sure) a very silly question. I have a script pulling together a couple of different QVDs and an Excel file to create a single report. I have two inline maps which I am using to correct a couple of fields, redirecting financials from one line of business to another, which are working as expected.

But here's my silly question - the inline maps are at the top of my script. Do I need to put the "Map...Using" statement before every data file load, or only once?

So like this:

Map LOB Using ChangeMap1;

Load LOB

Revenue_1

From QVD1.qvd;

Load LOB

Revenue_2

From Excel1.xlsx;

Map LOB Using ChangeMap1;

Load LOB

Revenue_1

From QVD1.qvd;

Map LOB Using ChangeMap1;

Load LOB

Revenue_2

From Excel1.xlsx;

I can't decide if it matters or not, and I suspect I am being a bit OCD in terms of making my script neat and tidy for the next person that comes along to deal with it!

Cheers

Lisa

Re: Map Using - where do I apply this?

Clever_Anjos — Tue, 24 May 2016 13:21:26 GMT

You need to put it only once.

If you want to be clearer thy using Applymap

Load Applymap('ChangeMap1',LOB) as LOB

Revenue_2

From Excel1.xlsx;

Re: Map Using - where do I apply this?

Tue, 24 May 2016 13:52:42 GMT

I thought ApplyMap was the equivalent of a VLOOKUP in Excel, so adding one column of additional data in, while Map Using allowed you to change existing data to something else.

Have I misunderstood Apply Map?

Re: Map Using - where do I apply this?

Clever_Anjos — Tue, 24 May 2016 18:33:25 GMT

You can add a column or map one existing as my example shows