Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how to change from in Load dynamically

Hi Friends,

I have text files in D drive with names JAN, FEB and  MAR. I am trying to load data for that month only and flag it with a column.

I used if filetime('D:\JAN.txt') then

Load * ,filebasename() as Flag.

from ....JAN.txt.

I want a code where if the month is FEB the code automatically loads the FEB data with flag FEB.

I dont want to change only FROM rest code remains the same.

Thanks


Tags (1)
1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: how to change from in Load dynamically

Let vMthNm= Upper(Month(Today()));

Load * ,filebasename() as Flag.

from ....$(vMthNm).txt.

1 Reply
anbu1984
Honored Contributor III

Re: how to change from in Load dynamically

Let vMthNm= Upper(Month(Today()));

Load * ,filebasename() as Flag.

from ....$(vMthNm).txt.

Community Browser