Dynamic Input tool error

Question

Team,

I am getting below error while using the Dynamic Input tool to get the separate xlsx file from the multiple sheet.

Error: Dynamic Input (4): The file "C:\Users\pthathe1\Documents\Alteryx\Input\FSA.xlsx|||14M02" has a different schema than the 1st file in the set.

Can anyone support to me to create the right work flow? if i am wrong.

The sample file i have attached below. In that 2 xls sheets available. I want to get those sheet in separate xlsx file. This is the sample file only, the actual file have 307 sheets.

Thanks..

Thathes. P

FSA.xlsx

pthathes · Answer

Dear Danilang,

Thank you so much for your wonderful support. Last four days i am searching for help who are expert in my organization. Finally, i got it from you.

Thanks

P. Thathes

danilang · Answer

Hi @pthathes

Here's a version that reads all the sheets in an excel file and uses a macro to write them out to separate .xslx files

The main file just reads the list of sheet names from the file and builds a full path name with the sheet for each record and passes this to the control parameter of the batch macro

The macro itself takes the data in the control parameter and changes the file name to be the sheet name, deletes the extra fields and writes out the data using the new file name.

Dan

Main.yxzp

pthathes · Answer

Hi FrederikE,

Thanks for your response. The work flow has been made that both sheet records in same xls.

Sorry ,,, My expectation is that i want to get the sheet 1 as a separate xls. And the sheet2 also has to separate xls in a folder. The xls file name should be 14M01 & 14M02 in a folder

Thanks

Thathes. P