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