Discussion board where members can get started with Qlik Sense.
how to upload
Provide sample sheets..
check out this:
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)
LOAD *, '$(FoundFile)' as SourceFile
FROM [$(FoundFile)] (ooxml, embedded labels, table is sheet1);
Set vConcatenate = Concatenate;
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
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.
Is your query related to QlikView or Qlik Sense? You've posted it to the Qlik Sense forum.