Condensing data from multiple columns into a single row

[MHS]

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

[AkimasaKajitani]

Hi @MHS 

Can you upload the data source file?

[MHS]

Hi Akimasa, 

Thanks for the help on this! I have a test file input attached to the workflow.  Please let me know if you need anything else. 

Matt

[Qiu]

@MHS 
Can you also provide a sample of your desired output?

[gabrielvilella]

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. 

[MHS]

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

[gabrielvilella]

What I did:

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