How to join two tables containing data?

Question

Hi,
I have a problem with one of workflows I built (attached).
I have a set of the data I split into header and data. The header is formatted to have the proper colors, fonts, etc. and I want to join header and data into one table which is finally split into separate files upon company codes from column C and saved to the location.
Whatever I do these two pieces of data (table with headers and table with data) do not match. Would you be able to support?
Also, I would like to add to every single output file separate tab with table for sign off of the data. How to do that (so final files contains one sheet with data and one sheet with sign-off form).

Desired outcome is in attached Template.xlsx, data file attached as Masterfile final.xlsx and workflow also attached.
Thanks in advance!

Template.xlsx

Masterfile final.xlsx

Alteryx+workflow.yxzp

DataNath · Answer

Hey @sylwestro in this case, I'd say the best option is to run this as a batch macro. The groups from your 3rd row would be what you feed into the upside down question mark, which then updates your control parameter. What this will do is run each group through the macro one at a time, outputting them as separate files. In order to not overwrite, you'll need to make a filename dynamically for each of the groups. There's a good thread on how to do that here, you would just use your grouping where they have used region:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-output-filename/td-p/911070

sylwestro · Answer

Hi DataNath,

We are almost there.

What I am looking for is to have first two rows as a header to be added to the report and the reports are saved to separate files upon the grouping from 3rd column.

So basically this shall be the header:

These are the data grouped by 3rd column:

At the end the hedaer shall be visible at every record change:

And finally I'd like to save the outcomes (header+data) to separate Excel files.

DataNath · Answer

You could do this by editing the header settings here:

And then also using the same formatting in a row rule, where the row # = 1, like so:

Which would give you the following:

Obviously I've just used a yellow background to show it working here, but you can add your formatting as you wish.

To get rid of the 'Field X' names, I just renamed all of the headers with a space, like so: