how to upload multiple excel sheets with different sheet names in one go

[Anonymous]

how to upload

[MK_QSL]

Provide sample sheets..

[sushil353]

check out this:

http://community.qlik.com/thread/54342

HTH
sushil

[ali_hijazi]

  where do you want to upload?

or you mean to load?

if load then check this out

for each FileExtension in 'xls','xlsx'

                    for each FoundFile in filelist( Root & '\*.' & FileExtension)

                              FileList:

                              $(vConcatenate)

                              LOAD *, '$(FoundFile)' as SourceFile

                              FROM [$(FoundFile)] (ooxml, embedded labels, table is sheet1);

                              Set vConcatenate = Concatenate;

                    next FoundFile

          next FileExtension

[Anonymous]

Manish the issue is that i get an excel sheet every day from my client

Each day the name of the workbook that i get is of different name because date changes

i save this file in a location and then upload on qlikview

each day i have to change the file name in the code

what should i do to not do this

[Anonymous]

When you load the sheet, on the left hand side, you'll see all the sheets.

You can simply tick on each sheet you want to import.

This is a screenshot of what I mean. I have three sheets, "Sheet One", "Another Sheet" and "Three!". As they are all ticked they'll all be uploaded together.

[#7]

Is your query related to QlikView or Qlik Sense? You've posted it to the Qlik Sense forum.

//Pedro