Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How I can store data from loads outside a loop.
Something like this:
(create a empty table)
For each ExcelFile in filelist ('*.xlsx')
Load * (...)
(store data into the empty table created above. increasing the data)
Next ExcelFile;
Assuming the field list is the same, concatenation to the already created table is automatic. You don't need to do anything.
-Rob