Add records to bottom of summarized report

Question

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_ · Answer

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.

Excel formula creations.yxmd

jessicawhite03 · Answer

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.

Erin · Answer

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.