Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
berstrom
New Contributor II

crossload multipile excel files

Hey!

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'

[$(vSheet)]:

NoConcatenate
load F1, F2, F3, F4
from [\file_*.xlsx] (ooxml, embedded labels, table is [$(vSheet)]

next;

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!

Best regards

Labels (4)
1 Solution

Accepted Solutions
Support
Support

Re: crossload multipile excel files

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:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

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.

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

2 Replies
Employee
Employee

Re: crossload multipile excel files

You could try using the vSheet variable as table name and do a Qualify *, keeping every table separated by the sheet.
Support
Support

Re: crossload multipile excel files

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:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

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.

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post