Look up based on month files

raadwiptec — Wed, 21 Jul 2021 21:25:52 GMT

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

topic Look up based on month files in QlikView

Look up based on month files