Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Load excel with for each

Hi,

I load in a excel file some tables with        "For each vSheet in 'Jan', 'Feb', .....

                                                               Load col1, col2

                                                               From [path]

                                                               (biff, no labels, header is 3 lines, table is $(vSheet))

                                                               Next;

Now i would like to do the same, but i would like to do the same with two excel files. Something like this:

                                                              

                                                               For each vFile in 'Path1', 'path2'

                                                               For each vSheet in 'Jan', 'Feb', ....

                                                               Load col1, col2

                                                               From [$vFile]

                                                               (biff, no labels, header is 3 lines, table is $(vSheet))

                                                               Next;

                                                               Next;

How is that possible?

1 Solution

Accepted Solutions
Highlighted

Re: Load excel with for each

Hi,

You are almost there!

Change this line, and that should work.

From [$(vFile)]

Hope that helps.

Miguel

2 Replies
Highlighted

Re: Load excel with for each

Hi,

You are almost there!

Change this line, and that should work.

From [$(vFile)]

Hope that helps.

Miguel

Not applicable

Re: Load excel with for each

Great, Thank you.

Everytime this small faults...