Hello All -
How do you load multiple worksheets from a single Excel spreadsheet file whereby the worksheets' attributes differ from each other.
What I found was:
'Loop Files' - ['Read Excel'] (as the nested operator) --> 'Append'
The 'Loop Files' provides me with a directory - do I just move the Excel spreadsheet to it's own folder even though it's a single file?
The 'Read Excel' provides with the import wizard - which only allows me to import one sheet.
I appreciate your help!
Dominic
