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
please reply it.
its urgent
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
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
Hi All,
Please reply it.
Regards
Ashish
Hi Ashiskumar,
Please attach some directories with example files.
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.
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
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
Ashish
How about something like:
Load * from C:\ashish\*\rahul.txt
and also
Load * from C:\ashish\*\abhishek .txt
Best Regards, Bill