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-Name...

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

[rohini]

Hi,

I have been trying this dynamic input tool, but in the Input data source template filed, we would input one sheet name, can you please let me know how would that select the next sheet or a set of sheet.

[T_Willins]

Hi Rohini,

This can be accomplished using a simple batch macro that doesn't use the Dynamic Input tool.  In the Input Data tool in the Batch Macro be sure update the  Output File Name as Field to File Name Only.  This allows you to use the file name for creating the tabs in the Output workbook as shown in the 3rd image.  The Output file workbook then has tabs as shown in the bottom image.  Let me know if you have questions.  If this solution works for you, please mark as complete to let the community know it has been solved.

Workflow

Barch Macro

[rohini]

Hi Thank you,

Can you please provide the workflows in yxmd as I am not able to unzip the file 

Thank you.

[T_Willins]

Hi @rohini,

Separate files are attached.

[rohini]

Hi,

Thank you for this. helped me. 

but I wanted one more solution, the data is from different excel and exported to one excel with different tabs. from the above I could export all data in one excel tab, but how would export in different tabs by specifying the tab names. Any way for that.

Regards

Rohini