Input data .xlsx files with different workbook and sheet names?

Question

Hello All

I tried to consider as input data a folder including all *xlsx files each files contains one sheet

The columns is always equal but the file name is different and also the sheet name is always different? e.g.

File   ABC 4564.xlsx /// d34

ABC 3476d.xlsx.  /// a32

RGT 456.xlsx.  /// Xyz  etc....

The content and columns are always the same....

any idea how this works? I tried to use the dynamic Input toll, but this requires a "fix" file name ?

Thanks for your thoughts!

horth007 · Answer

@ShankerV

This would be a monthly recurrent task,  I could have up to ten files *.xlsx and each file contains only one sheet one sheet.

But the file name will change each month and also the sheet name is changing. I only know that the columns and headers are always equal.

The solution should be also ensure that the workflow can run by "normal" without any adjustments in the workflow.

ShankerV · Answer

@horth007

As per the question, I understood that the file name is different and the sheet name is different.

sheet name is always different? e.g.

File   ABC 4564.xlsx /// d34

ABC 3476d.xlsx.  /// a32

RGT 456.xlsx.  /// Xyz  etc....

Was not aware that, one file has many sheets. I created and shared the workflow to read only 1 sheet from the Workbook.

If you need the support to read more than 1 sheets, let me know. Happy to help on that!!!!!

Many thanks

Shanker V

horth007 · Answer

@ShankerV  Thanks for this but this solution was not working. I have always sheet with a different file name and changing number of files. This would require I have a fix "Input Data Source Template

@mceleavey Thanks I will verify the links you sent! The workflow you shared can be not used as it seems the function included not matching my Alteryx version and I cannot update this.

In any case many thanks for your help!