I wrote an Automation Designer app to import all Excel files in a folder into one Oracle table. I am trying to import from the second tab in the Excel file(s), but the Import table definition loses it's column definition on the second pass and can't import the remainder files. Here is the order of operations:
File Iterator to Directory with extension .xlsm.
Copy file to a location with a static name.
Import the static name into table and direct the import to the second tab. The definition works well when the file is available to read setting up.
First loop or file works well, then the second file fails. I open the import table definition and the tab selected is checked, but the definition of columns (mapping) are gone.
It is possible that I can only import from the first tab? I moved the tab from the second position to the first position in all files and it works.
Appreciate any help and thank you in advance.