Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Dynamic Input And Merge Output

Inactive User
Not applicable

Hi All,

 

1.How to dynamically import excel files(multiple files) And excel sheets(sheet1,sheet2.....) ?

2.How to merge multiple output into single excel workbook with multiple sheet ?

 

Can anyone help ?

 

Thanks in Advance !

2 REPLIES 2
jcalteryx
Alteryx
Alteryx

 Hi Gursharan,

 

1. Are the the multiple files or excel sheets in the same schema? if they are in the same schema you can use a wild card entry for the multiple files and the dynamic input tool for the multiple sheets. For different schema you will need to use a batch macro input.

 

More information on samples here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

 

2. You can try the block until done tool and have multiple output tools make sure to specify the sheet number.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Block-Until-Done/td-p/895920

 

csclark
Alteryx
Alteryx

Hi Gursharan,

 

The links @jcalteryx posted are very useful. I have also attached a folder containing a workflow which demonstrates many of the different ways you can work with and input (as well as output) excel files. This includes examples of;

 

  • Bringing in many files with the same schema using a wildcard input
  • Bringing files from a Directory + Dynamic Input
  • Input files with Different Schema using a Macro
  • Input Multiple Sheets
  • Input Multiple Tabs with Different Schema
  • Input Multiple Tabs and Files
  • Idenitfy and Input the Most Recent File in folder
  • Output Multiple Sheets to 1 Excel File (the Block Until Done Method shared previously is another way!)

Just download the zip, go to Workflow -> Input Methods. If you've found our suggestions useful, please mark as a solution and give us a thumbs-up, it helps users like yourself to find this information more quickly :)

 

Labels