We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to join 5sheets from 1 excel file

Hi2023
8 - Asteroid

Hi,

 

 

How do you join 5 sheets from 1 excel file? I thought I could do a formula to pull the sheets out and then join them?

 

I have 5 sheets Trans, Ref note, Trans date, account, sub

 

thanks

24 REPLIES 24
ShankerV
17 - Castor

Hi @Hi2023 

 

First you need to input the sheet names in the dynamic tool.

Then you need to used Dynamic input tool to connect all 5 sheets.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Hi2023 

 

Step 1: Use the input tool 

Select the Highlighted Option

 

ShankerV_0-1668787327228.png

 

ShankerV
17 - Castor

It will read all the sheet names

 

ShankerV_0-1668787666271.png

 

ShankerV
17 - Castor

Step 2:

 

Use the Dynamic input tool

 

ShankerV_0-1668787767305.png

 

ShankerV
17 - Castor

@Hi2023 

 

Check and let me know if it worked for your file.

 

Many thanks

Shanker V

ShankerV
17 - Castor

@Hi2023 

 

Explaining a use case below for you.

 

Step 1: Input .xlsx file

 

ShankerV_0-1668790567980.png

 

ShankerV_1-1668790581139.png

 

 

Step 2: Input tool

 

ShankerV_2-1668790657251.png

 

Step 3: 

 

Dynamic input tool

 

ShankerV_3-1668790728673.png

 

 

Many thanks

Shanker V

 

ShankerV
17 - Castor

@Hi2023 

 

One thing you need to do prior importing the data's from all 5 sheets are , the Schema should be same.

 

i.e, the order of the columns in all 5 sheets should be same.

 

Or the data's will be merged but it will read in different column names matching to the first input sheet.

 

Many thanks

Shanker V

Hi2023
8 - Asteroid

after the dynamic input tool, how do I retrieve and join only the 2 sheets I need and after the join I need to filter for dups within the data?

ShankerV
17 - Castor

@Hi2023 

 

Sure, its possible.

 

Few minutes, will share the possible solution with use case.

 

Many thanks

Shanker V

Labels
Top Solution Authors