Map Using - where do I apply this?

[#1]

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;

OR

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

[Clever_Anjos]

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;

[#3]

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?

[Clever_Anjos]

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