topic Re: How to get the rows to be aligned into one row in Alteryx Designer Desktop Discussions

How to get the rows to be aligned into one row

jessy_chow — Tue, 26 Aug 2025 15:01:29 GMT

Here are my results from 2 summarize.

I need to take SUM_610200 Office Supplies / Sum_FTE Total. (37982/1224.84) However since they are are on different rows, I am unable to use the formula function to do the calculation. How can I the results to look like the following.

Sum_FTE Total	Sum_610200 Office Supplies
1224.84	37982

Re: How to get the rows to be aligned into one row

davidskaife — Tue, 26 Aug 2025 15:05:11 GMT

Hi @jessy_chow

Assuming your two records are coming in from two separate streams just use the Append Fields tool

Re: How to get the rows to be aligned into one row

jrlindem — Tue, 26 Aug 2025 15:05:19 GMT

Can you provide more of the workflow upstream to this? Seeing the SUM_ prefixes i'm guessing you've got a summarize tool in your workflow, but exploring the Transform tools to modify your workflow to include a Cross Tab or Transpose will likely help. But if you can provide more context, I'm sure someone can build you out a proof-of-concept.

Re: How to get the rows to be aligned into one row

JosephSerpis — Tue, 26 Aug 2025 15:07:48 GMT

Hi @jessy_chow you may need to apply a filters before your summarise to remove any Null records from both columns. Using the filter tool would achieve this. I would add two filters filter out the Null records as a proof on concept before you summarise to see if this resolve the issue and gets all the data aligned.

Re: How to get the rows to be aligned into one row

jessy_chow — Tue, 26 Aug 2025 15:07:37 GMT

Thanks! This worked!