multiple input into one specified tab names

rohini

Hi All,

I have different set of csv files as input more than 17 files, i want to read each file name and paste the content in other excel file in a specified tab.

I tried the dynamic input tool to get the file name and path name. but i am not able to proceed as I am not sure of how to select a specific sheet from the whole path and input that  in a specified tab.

For eg: I have list of cities in Africa as a separate excel file and list of cities in America in a specified excel file, i want to import both the file and paste the content in one excel file called cities but in different tabs like cities in Africa and cites in America.

Please help.

Regards

Rohini

Emil_Kos

Hi @rohini,

I am not sure if you will have specific sheet names in the CSV files.

I was under impression that CSV file can have only one sheet.

Still, I searched for an answer I found a post written by @Thableaus that should be able to help you if you want to use excel files with multiple sheet names

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-List-of-Excel-Sheet-Names/m-p/367644/highlight/true#M67467

Afterwards, you just need to use filters in order to split the data. 

Dynamic_Input.yxmd