Loading of Data files with different Version Nr.

[matamat2906]

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!

[MK_QSL]

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

[Kushal_Chawda]

@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

[matamat2906]

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,