topic Re: crossload multipile excel files in QlikView

crossload multipile excel files

berstrom — Sat, 16 Nov 2024 20:27:16 GMT

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

Re: crossload multipile excel files

Lisa_P — Tue, 16 Jul 2019 00:57:38 GMT

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

Re: crossload multipile excel files

Brett_Bleess — Wed, 07 Aug 2019 19:23:18 GMT

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