For Each Loop Limitation

[erric3210]

Hi All,

I have recently faced one issue with "For Each Loop".

Let me explain the issue:

I got an error when I try to reload with n no. of sheets and I've written names for each sheet in a single line. Like this:

FOR EACH vSheet IN 'California','[New Jersey]','[Los Angeles]', many more sheets with City Names in it ............. there are n no. of sheets

I think qlikview has set limit for characters to be used in a single horizontal line which I think I've exceeded.

After fixed no. of characters, whatever I'm writing is coming to the next line.

So, the issue is that For Loop only accept the values written in the single line. Since, I've so many State & Country details so how to handle this scenario.

If someone has worked on such requirement than please let me know.

Regards,
Eric

[MayilVahanan · Accepted solution]

Hi @erric3210 

PFR

https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit...

https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html

Hope above links will help you.

[erric3210]

hi @MayilVahanan 

Thanks for sharing the links. It works for me.

Regards,

Eric