How to get the rows to be aligned into one row

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

Designer Cloud

Accepted answers

davidskaife

Hi @jessy_chow

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

All comments

davidskaife

Hi @jessy_chow

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

jrlindem

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.

JosephSerpis

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.

jessy_chow

Thanks! This worked!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703