topic Re: "For each" issue in QlikView

"For each" issue

Randomize1978 — Wed, 17 Jun 2020 08:52:06 GMT

Hello everyone,

i have a problem and will be glad to get your assistant.

i need to load 5 excel files(one sheet each) where i need to bring every week the latest file for each one of them/

one is for Budget with a unique name and 4 for each team.

what i planned to do was to run" for each in file list" and concatenate between them.

the budget is working,my problem is the other 4.

the files name is like this "businessteams 02062020-094512 team1.xlsx"

they all start with "businessteams " with date and time in the middle but ends with team number.

now,in the budget the start of the string is uniqe so i wrote

FOR EACH file in FileList('$(vFilePath)\Weekly budget*.xlsx') and it works fine but here i cannot found a solution to retrieve the last file for each time as the team number is in the end of the string(tried FOR EACH file in FileList('$(vFilePath)\*team1.xlsx')

hope its clear and will be glad to get your help ,

thanks!

Re: "For each" issue

raji6763 — Wed, 17 Jun 2020 11:40:24 GMT

hi @Randomize1978 ,

could you please try this?they all start with "businessteams " with date and time.so you can use businessteams*.xlsx instead of *team1.xlsx

(tried FOR EACH file in FileList('$(vFilePath)\*team1.xlsx')

did you try with next file syntax

regards,

raji

Re: "For each" issue

Randomize1978 — Wed, 17 Jun 2020 15:45:08 GMT

hi @raji6763 ,

thanks, can you please elaborate?

when i write businessteams* it is not working maybe because there are 4 files that fetched from that.

can you please show me how to do it in the script?

Re: "For each" issue

raji6763 — Fri, 19 Jun 2020 06:37:07 GMT

hi @Randomize1978 ,

you can load the 4 files without using for each statement.

All team filename start with businessteams so try the below:

the * will pull your all 4 files

Regards,

raji

Re: "For each" issue

Randomize1978 — Sun, 21 Jun 2020 11:43:08 GMT

thank you!