Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different files in sheets

Hi! I am new to QV so I might be asking something very trivial. I want to load different excel files to different sheets. They don't have the same columns and I don't care to link the sheets for now. Just work with excel A in the first sheet and excel B in the second. But I seem to get stuck with the same file as input.

Thanks

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

That should be pretty simple.

  • Open your script editor
  • Load as many Excel sheets as you want, but make sure that they end up in different tables. To be safe, put the NOCONCATENATE keyword before each LOAD.
  • Reload
  • In your document, create as many sheets as necessary
  • On each sheet, create a new object to show data from a different internal table.

That's about it. Now, what do you mean by "...stuck with the same file as input..."? Do you want to load multiple sheets from the same Excel? Then change the sheet name at the end of each LOAD statement. You're stuck with the same Excel loading over and over? Use the Table Files... button to explicitly load another Excel.

Otherwise please clarify your last sentence. Thanks.

Peter

View solution in original post

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

That should be pretty simple.

  • Open your script editor
  • Load as many Excel sheets as you want, but make sure that they end up in different tables. To be safe, put the NOCONCATENATE keyword before each LOAD.
  • Reload
  • In your document, create as many sheets as necessary
  • On each sheet, create a new object to show data from a different internal table.

That's about it. Now, what do you mean by "...stuck with the same file as input..."? Do you want to load multiple sheets from the same Excel? Then change the sheet name at the end of each LOAD statement. You're stuck with the same Excel loading over and over? Use the Table Files... button to explicitly load another Excel.

Otherwise please clarify your last sentence. Thanks.

Peter

Not applicable
Author

It worked fine, it was the multiple load I was not doing right.

Thanks for the help!