Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Loading

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

1 Solution

Accepted Solutions
MVP
MVP

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.

View solution in original post

5 Replies
Creator III
Creator III

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

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

MVP
MVP

And,

date format should be enclosed within quotes, like:

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

Creator III
Creator III

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

MVP
MVP

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.

View solution in original post

Creator III
Creator III

Thank you Tresesco.