Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

Look up based on month files

I have Monthly Mapping Files

Jan_DLoad, Feb_DLoad, Mar_DLoad xlsx Files.. Which has Date as Field

Date | Player |

01/01/2021 | MLKAS

01/01/2021 | BLOOM

Similiarly Feb File

01/02/2021 | KARMOS

01/02/2021 | CASSE

 

We have a Source File which needs to Look up these Files, The Source Files as Date Column called 'Actual Date'

For Ex: 18/01/2021 ,24/2/2021, 12/03/2021

This actual date needs to look up on the mapping files and check if the Actual Date is Jan then it has to retrieve information from Jan mapping File else if February then Feb - Mapping File etc..

 

Thanks to suggest..

 

 

Labels (1)
0 Replies