Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Merge 3 excel files into one with dynamic sheet names

akvsachin
8 - Asteroid

workflow.jpg

What I have:

3 input excel files and I've Extracted filenames (3) from the file name
Correspondingly sorted data for each file (3)

What I need:

An output file where the extracted filenames are used as sheet names, with the sorted data from the corresponding file in each sheet.

Also, please give a suggestion If I can do the same thing while using FileBrowse Tool + Action Tool

1 REPLY 1
nagakavyasri
12 - Quasar

@akvsachin Can use any of 2 workflows attached.

Labels
Top Solution Authors