Merge data in one excel and also required TAB wise data

Question

Hi Team,

While preparing the Alteryx WF, I have two output files "Invoice overview report" & "Journal N detail" where in "WBS Reference 2" are common in both the files. but I want the data like as "Required Data" file in which both the data merge in one separate TAB on the basis of "WBS Reference 2". Refer all three files.

Regards,

Mahesh

Invoice overview report.xlsx

Journal N detail.xlsx

Required Data.xlsx

Maheshp · Answer

Hi,

Not able to get, could you please help us to provide a workflow. Output should be the same like " required data" file with the help of two other input files.

OTrieger · Answer

I see. When writing out an excel file you need to define what is the tab name, there will be several ways how to write the data out, you can do it with batch macro that will do it based on the tab name or can use multiple output tool, only if you choose this way use any way to synchronizing the saving, such as parallel block until done etc.. You define the tab name after the 3 pipes (|||), so it will be something as .xlsx|||tabname

Maheshp · Answer

Yes, this we want in Alteryx Workflow. I have two files "Invoice overview report" & "Journal N detail" with the help of these files i want both files data in one excel sheet which would be output but TAB wise. result provided in "Required Data" files. It should be look like that.