Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

MApping Load

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
 

1.PNG

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

2.PNG

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

3 Replies
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.

 

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
dunnalahk123
Creator III
Creator III
Author

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

 

T1.PNG

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

 

2.PNG

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?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago