topic Re: Loading of Data files with different Version Nr. in Management & Governance

Loading of Data files with different Version Nr.

matamat2906 — Sat, 16 Nov 2024 17:57:23 GMT

Hello all,

I have more files that have same "Start name" but other "Ending" due to Upload number.

Exampel:

XYZ_0

XYZ_1

XYZ_2

I can make connection for every and that is not problem, but i have every day new Upload number and i need to figur out have can qlik load all of Data that have "XYZ_".

Thank you in advance!

Re: Loading of Data files with different Version Nr.

MK_QSL — Sun, 18 Oct 2020 14:20:39 GMT

Use for each loop... See below blog for further help..

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

Re: Loading of Data files with different Version Nr.

Kushal_Chawda — Sun, 18 Oct 2020 15:15:53 GMT

@matamat2906 if field names are identical in all the files then you can simply use

Data:

LOAD *

FROM XYZ_*;

If field names are different then you may need to use loops

Re: Loading of Data files with different Version Nr.

matamat2906 — Sun, 18 Oct 2020 19:23:48 GMT

Hi guys,

thx for you suggestions, i have made it with FOR..NEXT.. (see the pic).

I have one more question how it can work in a case of skipped Upload number?!

Exampel: upload number 1 is missing:

XYZ_0

XYZ_2

XYZ_3

Kr,