how to change from in Load dynamically

Mon, 06 Oct 2014 12:28:47 GMT

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

Re: how to change from in Load dynamically

anbu1984 — Mon, 06 Oct 2014 12:36:11 GMT

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

Load * ,filebasename() as Flag.

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