Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Load data from different folder

Hi

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

please treat as urgent.

Thanks in advance

Regards

Ashish

18 Replies
Not applicable

Re: Load data from different folder

please reply it.

its urgent

bill_markham
Not applicable

Re: Load data from different folder

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

Not applicable

Re: Load data from different folder

I want script which extract data from each folder dynamically.


Folder NameFile name
Arahul.txt
ashish.txt
arunesh.txt
abhishek.txt
Brahul.txt
ashish.txt
arunesh.txt
abhishek.txt
Crahul.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

Not applicable

Re: Load data from different folder

Hi All,

Please reply it.

Regards

Ashish

fred_s
Not applicable

Re: Load data from different folder


Hi Ashiskumar,

Please attach some directories with example files.

Not applicable

Re: Load data from different folder

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.

Not applicable

Re: Load data from different folder

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

Not applicable

Re: Load data from different folder

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

bill_markham
Not applicable

Re: Re: Load data from different folder

Ashish

How about something like:


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

and also


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

Best Regards,    Bill