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
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
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:
What if there is another sheet that doesnt have a common column, can I still those sheets columnsas well ?
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.
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 .