Same Excel File with a changing Sheet Name

Hi,

An ERP exports every day an Excel file with the same filename, but with a different sheet name (e.g. based on the number of jobs since the beginning of the session).
There’s only a sheet in the Excel file.

Is there a way to execute the import automatically?

Thanks,
Michel

Hi Michel,

The only way would be running the “Spreadsheet metadata” transformation to obtain a list of sheets in spreadsheet, and then iterate with the sheet name as parameter.

Thanks, Dmitry
We asked for a .csv export in order to avoid that complexity