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

[Hi2023]

Yes, I have multiple files that all have 5 sheets but I only need to join certain sheets together. And I also need to join those sheets together

[KrishnaChithrathil]

@Hi2023 

I'm attaching a workflow here. Please have a look.

So I've an excel, having 2 sheets 'Trans' & 'Acc'

Both sheets have a common column named 'Trans'.

I joined both the sheets by 'Trans' column. If this is what you're looking for, you can download the workflow and check 😃

Excel Inputs:

Output:

[Hi2023]

What if there is another sheet that doesnt have a common column, can I still those sheets columnsas well ?

[KrishnaChithrathil]

@Hi2023 

I don't think we can normally join it.

But we can think of a workaround.

1. Pull out all the sheet data using dynamic Input.

2. Give a Record ID for each sheet data.

3. Join it using Record ID. (either use Join Tool or Join Multiple) While Joining, you can uncheck the Record ID.

Just give it a try.  I hope this would work. 

[KrishnaChithrathil]

@Hi2023

There might be a better workaround for this. I'm also open for any suggestion. 😀

I've added a new sheet having no common column .