1 Reply Latest reply: Oct 6, 2014 8:36 AM by anbu cheliyan RSS

    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