Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Let vMthNm= Upper(Month(Today()));
Load * ,filebasename() as Flag.
from ....$(vMthNm).txt.
Let vMthNm= Upper(Month(Today()));
Load * ,filebasename() as Flag.
from ....$(vMthNm).txt.