MApping Load

[dunnalahk123]

Hi,

can some help me how to write Apply map for below

basically from below table1 i am pulling date values where NewValue Text="onhold" so in my first QVD i will get below 2 Date values

Note: Common field for both QVD's is Project ID

Date1

8/18/2020

10/18/2020

and then again i am pulling date values where OLDValue Text="onhold" so in my second QVD i will get below 3 values

Date2

6/1/2020 0:00

10/11/2020

11/4/2020

so finally once i apply apply map i want desired output table how can i write

may be i am thinking always take from Last old value text on hold Date and then go upwards.

[Thiago_Justen_]

Hi there,

Considering what you give us let me suggest you something.

Map_Date1:

Mapping

Load

        [Project ID],

         Date1

From Your_Date1_QVD;

Map_Date2:

Mapping

Load

        [Project ID],

         Date2

From Your_Date2_QVD;

Table:

Load

          Your_Fields,

          ApplyMap('Map_Date1', [Project ID], Null())           As "Old Value Text",

          ApplyMap('Map_Date2', [Project ID], Null())           As "New Value Text"

From Your_Table_QVD;

Hope it helps you.

[dunnalahk123]

Hi,

no, it was not Working as expected.

i combined both date QVD's Date1 and Date2

T:
Load * From
[$(QVD_Path_CD)\LES_GSD_HOLDClosuredate.qvd] (qvd);
Concatenate
Load * From
[$(QVD_Path_CD)\LES_GSD_HOLDClosuredate2.qvd] (qvd);

STORE T into [$(QVD_Path_CD)\T.qvd] (qvd);
 
Drop table T;

and i got below out put

Now after applying apply MAp  i want to get values like below  .

[Thiago_Justen_]

Hi @dunnalahk123,

Have you tried to run my suggestion?

Where in your code are you using applymap as I wrote?

I can't see your point by reading your response.

Could you please give me more detailed information?