topic Re: Load data from different folder in QlikView

Load data from different folder

Thu, 21 Nov 2013 17:42:27 GMT

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

please treat as urgent.

Thanks in advance

Regards

Ashish

Re: Load data from different folder

Thu, 21 Nov 2013 18:37:06 GMT

please reply it.

its urgent

Re: Load data from different folder

Anonymous — Thu, 21 Nov 2013 19:02:30 GMT

Ashish

In the QV Desktop script editor click the <Table Files> button, navigate to your first text file and follow the prompts

When you have sorted the first file,click the <Table Files>, navigate to your first text file and follow the prompts...

Best Regards, Bill

Re: Load data from different folder

Thu, 21 Nov 2013 20:40:03 GMT

I want script which extract data from each folder dynamically.

Folder Name	File name
A	rahul.txt
	ashish.txt
	arunesh.txt
	abhishek.txt
B	rahul.txt
	ashish.txt
	arunesh.txt
	abhishek.txt
C	rahul.txt
	ashish.txt
	arunesh.txt
	abhishek.txt

For every month folder is increase.

I want load rahul and abhishek file only from each folder dynamically not manual for every month.

Regards

Ashish

Re: Load data from different folder

Thu, 21 Nov 2013 20:46:11 GMT

Hi All,

Please reply it.

Regards

Ashish

Re: Load data from different folder

fred_s — Thu, 21 Nov 2013 20:53:56 GMT

Hi Ashiskumar,

Please attach some directories with example files.

Re: Load data from different folder

Thu, 21 Nov 2013 21:03:17 GMT

Ashish,

I don't have the code ready for you. But if you can download the Qlikview Governance dashboard which reads Matadata of QVWs n QVDs from different folder locations and analyse the code, that should solve ur issue.

Re: Load data from different folder

Thu, 21 Nov 2013 21:05:44 GMT

In my above post i already explain.

file is highly confessedly so i can not share it.

Dir- C:\ashish\

In Dir i have four below list of folder.

Each folder contenting below list file.

rahul.txt

ashish.txt

arunesh.txt

abhishek.txt

Note- every month number of folder is increase.

I want script which dynamicarlly read rahul and ashish file in each folder.

Regards

Ashish

Re: Load data from different folder

Thu, 21 Nov 2013 21:08:16 GMT

In my script i have manually added dir name but i want dynamicarlly for one file only .

for each dir in 'a','b','3'

LOAD id,

name,

FileDir()

FROM

(ooxml, embedded labels, table is Sheet1);

next;

Regards

Ashish

Re: Re: Load data from different folder

Anonymous — Thu, 21 Nov 2013 21:12:17 GMT

Ashish

How about something like:

Load * from C:\ashish\*\rahul.txt

and also

Load * from C:\ashish\*\abhishek .txt

Best Regards, Bill

Re: Re: Load data from different folder

Thu, 21 Nov 2013 21:31:20 GMT

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

Re: Load data from different folder

Anonymous — Thu, 21 Nov 2013 21:43:23 GMT

Ashish

Yup I know, have you tested it ?

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

Best Regards, Bill

Re: Load data from different folder

Thu, 21 Nov 2013 21:52:21 GMT

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

Re: Load data from different folder

Thu, 21 Nov 2013 22:32:49 GMT

please help me urgent basic.

Regards

Ashish

Re: Load data from different folder

Fri, 22 Nov 2013 07:27:50 GMT

Hi,

Please help me it is urgent.

Regards

Ashish

Re: Load data from different folder

Fri, 22 Nov 2013 09:24:39 GMT

Urgent please help some one.

Re: Load data from different folder

jonathandienst — Fri, 22 Nov 2013 09:48:21 GMT

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

Re: Load data from different folder

Fri, 22 Nov 2013 09:51:23 GMT

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

Did you see this thread ?

Some code could be interesting.

Fabrice

Re: Load data from different folder

Fri, 22 Nov 2013 10:01:59 GMT

Hi,

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

Hope this helps!

Thanks,

Sai