How to join 5sheets from 1 excel file

[Hi2023]

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

[ShankerV]

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]

Hi @Hi2023 

Step 1: Use the input tool 

Select the Highlighted Option

[ShankerV]

It will read all the sheet names

[ShankerV]

Step 2:

Use the Dynamic input tool

[ShankerV]

@Hi2023 

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

Many thanks

Shanker V

[ShankerV]

@Hi2023 

Explaining a use case below for you.

Step 1: Input .xlsx file

Step 2: Input tool

Step 3: 

Dynamic input tool

Many thanks

Shanker V

[ShankerV]

@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]

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]

@Hi2023 

Sure, its possible.

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

Many thanks

Shanker V