Load data from different folder

[#1]

Hi

How i can load particular  two text file form different folder.

please treat as urgent.

Thanks in advance

Regards

Ashish

[#2]

I don't want to do manually for every month.

[Anonymous]

Ashish

Yup I know, have you tested it ?

Or maybe I did not understand what you are trying to do.

Best Regards,    Bill

[#4]

i want to load txt file from different different folder dynamically.

[#5]

please help me urgent basic.

Regards

Ashish

[#6]

Hi,

Please help me it is urgent.

Regards

Ashish

[#7]

Urgent please help some one.

[jonathandienst]

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

[#9]

http://community.qlik.com/thread/99754

Did you see this thread ?

Some code could be interesting.

Fabrice

[#10]

Hi,

Please refer to the link: http://community.qlik.com/thread/62449

Hope this helps!

Thanks,

Sai