Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How i can load particular two text file form different folder.
please treat as urgent.
Thanks in advance
Regards
Ashish
I don't want to do manually for every month.
Ashish
Yup I know, have you tested it ?
Or maybe I did not understand what you are trying to do.
Best Regards, Bill
i want to load txt file from different different folder dynamically.
please help me urgent basic.
Regards
Ashish
Hi,
Please help me it is urgent.
Regards
Ashish
Urgent please help some one.
Hi
This is a framework for dynamically loading files with common structure from a set of directories:
Set vBase = \\QvData\Monthly;
Foreach vDir in DirList('$(vBase)\*')
Foreach vFile in FileList(vDir)
Let vBase = SubField(vFile, '\', -1)
Let vDate = Date(Date#(SubField(vBase, '.', 1), 'YYYYMM'));
MonthlyData:
LOAD ...
...
'$(vDate)' As FileDate,
FileName() As FileSource
From [$(vDir)]
...;
Next
Next
This assumes that the files have the same structure and are named YYYYMM.ddd where Y = year, M = month and ddd = any extension
HTH
Jonathan
http://community.qlik.com/thread/99754
Did you see this thread ?
Some code could be interesting.
Fabrice