topic Re: Loading in QlikView

Loading

ganeshreddy — Wed, 25 Nov 2015 10:45:44 GMT

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

Re: Loading

roger_stone — Wed, 25 Nov 2015 10:54:37 GMT

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

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

Re: Loading

tresB — Wed, 25 Nov 2015 11:00:38 GMT

And,

date format should be enclosed within quotes, like:

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

Re: Loading

ganeshreddy — Wed, 25 Nov 2015 11:09:48 GMT

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

Re: Loading

tresB — Wed, 25 Nov 2015 11:20:15 GMT

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.

Re: Loading

ganeshreddy — Wed, 25 Nov 2015 11:31:39 GMT

Thank you Tresesco.