Add records to bottom of summarized report

[jessicawhite03]

Hello, I have created a system upload report which is very specific on the format and placement of data. I have summarized all the data I need to produce the report but need to add these field to the bottom of a few columns. How can I do this? 

Previous formula in excel to get the first field to populate. 

[Gaurav_Dhama_]

Are you trying to add data to your output template, without affecting its column order?

Does the output file already exist to which you want to append? Or do you want to create that out of alteryx?

[Erin]

The union tool allows you to stack data vertically. If the field names are the same, the default Auto Config by Name should work. Make sure to set the order of the output so that the summarized row is always on the bottom. This will work in the classic engine, but it might not if you're using AMP because the sort can get weird. 

[jessicawhite03]

I am wanting Alteryx to create. The "B" and the "U0I" will always be the same, however, the "Asd" will need to have an If than statement. 

[Gaurav_Dhama_]

Ok so you want to create an output which consists of excel formulas as well as values. Check out the attached workflow.

Note that some excel formulas are fairly new to excel, and in those formulas, you will get #NAME error. NUMBERVALUE is one such function. Without that it works flawlessly.