I want to connect multiple sheets from one file and add columns for each sheet name

[Ardueeee]

I want to connect multiple sheets from one file and add columns for each sheet name.

I don't know what to do after getting the Sheet Names by specifying "import only the list of sheet names" in the input tool. I know to use the Dynamic Input tool, but I don't understand the options and other settings.

Please help me if you know the solution.

Thank you!

[fmvizcaino · Accepted solution]

Hi @Ardueeee ,

I'm attaching an example showing how to combine sheetnames column with the dynamic output tool.

For this to work, all sheets must have the same structure.

Best,

Fernando Vizcaino

[Ardueeee]

Hi fmvizcaino,

I could resolve the problem by your suggestion.

Thank you for your kindness!

Best regards

Kohei

[BenMoss]

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!