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]

please reply it.

its urgent

[Anonymous]

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

[#4]

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

[#5]

Hi All,

Please reply it.

Regards

Ashish

[fred_s]

Hi Ashiskumar,

Please attach some directories with example files.

[#7]

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.

[#8]

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.

A,

B,

C,

D

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

[#9]

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

[Anonymous]

Ashish

How about something like:

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

and also

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

Best Regards,    Bill