Loading

[ganeshreddy]

Hi All,

In the given scenario how to load only today's data, i have got txt  files in network drive which consists time stamp on their file name. Right now data structure is not matching in my script. How to resolve this.

Please find attached.

Best Regards,

Ganesh

[roger_stone]

Your variable is defining the date wrongly - let vdate=Date(today(),MMDDYYYY)

Needs to be DDMMYYYY, and within quotes - 'DDMMYYYY'

[tresesco]

And,

date format should be enclosed within quotes, like:

vdate=Date(today(), 'DDMMYYYY')

[ganeshreddy]

Hi Tresesco,

I agree with you piece of code, even know i am getting error like 'system cannot find the path specified' because file name consists time in the end. How to rectify this?

Regards,

Ganesh

[tresesco · Accepted solution]

let vdate=Date(today(),'DDMMYYYY');

LOAD sn,

     rm

FROM

TNA_$(vdate)*.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

This is working fine with me. Reconfirm your code as shown above and reconfirm the path you are using.

[ganeshreddy]

Thank you Tresesco.