how to change from in Load dynamically

[#1]

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

[anbu1984 · Accepted solution]

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

Load * ,filebasename() as Flag.

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