I found a similar post to answer some of my questions, but there are differences in my application that complicate this procedure.
I am referencing this post: http://community.qlik.com/message/440398#440398
For each of the CSV files I have, the tab is the same as the file name. If you look at the sample file provided, wherever 'Sheet1' is used, I need to change that to the 'filename' for each file.
Should I try to modify the existing script using
{
| Filee=peek( 'filename', i, 'master' ); |
}
Or should I try to use something like this?
{
Load *, filename( ) as X from
C:\UserFiles\abc.txt
}
Wondering if this statement will work:
{
master:
LOAD filename,
folder
FROM
address.xlsx
(ooxml, embedded labels, table is X);
}
Thanks in advance
