Discussion Board for collaboration on QlikView Scripting.
I am trying to load multiple excel files and to generate cross tables for each of those files without them concatenating. My approach looks like this:
First I load the tables from the respective tables from all files from the file folder using the wild card '*'.
for each vSheet in 'sheet 1', 'sheet 2', 'sheet 3'
NoConcatenateload F1, F2, F3, F4from [\file_*.xlsx] (ooxml, embedded labels, table is [$(vSheet)]
Now I want to generate the crosstables in a way that they are not concatenated, whereas renaming the field names manually is not an option, since I've got over 100 files to load from.
Would be very happy about any help!
Go to Solution.
Wondering if Lisa's comment helped or not? If it did, be sure to give her credit by clicking the Accept as Solution button on her post.
If not, check the following Design Blog post, it might help further:
If you got things figured out, you can post what you did and mark that as the solution such that others can learn from what you did.
View solution in original post