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]

@Hi2023 

I am breaking your question to 2 answer easily.

1. How to input only 2 sheets out of 5 sheets.

The best the way to do if filter the sheet names which you need to join.

Screenshot attached for your reference below.

Output:

Only 2 sheets datas will be inputted.

Many thanks

Shanker V

[ShankerV]

Hi @Hi2023 

To answer your second question to remove the duplicates if any.

Use the Unique tool to remove the duplicates, post joining 2 sheets.

Hope this resolves your issue.

Many thanks

Shanker V

[Hi2023]

I  assume its not working because those 2 sheets have diff columns? how can I fix this?

It is only pulling one sheet out of the filter.

thanks!

[ShankerV]

@Hi2023 

Can you share the excel sheet and which 2 sheets you are trying to input.

Will find a workaround solution. 

Many thanks

Shanker V

[Hi2023]

It wont let me add a file for some reason

the 2 sheets I need within 1 excel file

First, is the 'trans' sheet which has 9 columns:

Trans, recvd, checkoutdate, insur, pt, address, city, state, loc#

Second, the other sheet I need from this is the 'acc' sheet which has 6 columns:

Trans(same as 'trans' sheet first column), alter#, accdrop, PCI#, update, date

I need to join these2 sheets together 

thanks

[Hi2023]

Hi, so I would do this after the dynamic tool to pull the sheets out?

even with the columns being diff?

[Hi2023]

I guess I am not understanding how to join 3 sheets (now I need 3 sheets together) from one report?

I can pull the sheets out but then how do I get it to then merge the columns with a unique identifier as the trans #?

thanks

[trsali]

@Hi2023 Attached is how you will join multiple sheets into one excel.

To add another sheet to the workflow you can copy and paste the other inputs and paste it into the white space (canvas), then change the configuration below to locate your other sheets.

[Hi2023]

Also, since the schema (columns) are not all the same, whats the best option? 

I do want the columns that are the same within the sheets to be joined

[KrishnaChithrathil]

@Hi2023 

You've one excel having five sheets, with different set of columns. However, each sheet has a set of same columns, which you need to join.

Is my understanding correct?