Condensing data from multiple columns into a single row

Question

Hello Alteryx Community!

I have run across another issue with a workflow that I am hoping that more experienced members of the community can help me with.  I am attempting to consolidate data that is located across multiple columns and rows into a single row of data.  In order for me to come to the calculations that need to be consolidated, I am measure the difference between timestamps with the multi-row formula tool from one row to the next.  The goal being to have one row for an individual issue_id with all the associated columns worth of data in that row.  In some cases, we will have more than one value for an issue_id in that respective column and in this case would need to be a sum of the individual duration's.  I have run the workflow in differing configurations with multiple join tools without any luck.  Thanks for the help and let me know if you have any questions.

Thanks,

Matt

Test workflow 1.28.2022.yxmd

gabrielvilella · Answer

What I did:

* Insert a multi field formula to parse the date time fields.
* Change all multi row formulas to Int32 and remove quotation marks from the 0 on the expressions
* Insert a summarize at the end
* Remove the Sum_ prefix

Test workflow 1.28.2022.yxmd

MHS · Answer

Hello Everyone,

I have fixed the prior Alteryx test file and attached a mock-up of the desired output.  For the output I am looking to have the issue_id as the unique identifier and essentially have a roll-up of all row data for that issue_id into one row with the others to be removed from the ouput.

Thanks again for all the help on this and let me know if you have any questions.

Matt

Test workflow 2.11.2022.yxzp

Output test file 2.11.2022.xlsx

gabrielvilella · Answer

A simple solution would be using a summarize, group by issue_id and sum all the other columns. But I am not sure if that is what you want. Also, I ran your workflow and all the results from those multi row formulas have only zeros and nulls.