Group and concatenate records with multiple variables as individual rows

[jannet2014]

Hello,

I have a table below where I am trying to concatenate each row and group it by Request_ID. In Alteryx, I am using the Transpose tool to convert columns into rows and then Summary tool to group by Request_ID and concatenate a newly created column with values.

Request_ID	ID_Int	Line_Int	Workflow_Int
710	1970	4	2
710	1971	4	2
710	1972	5	3
710	1973	5	2
710	1974	5	2

However, since I am grouping by Request_ID, the Summary tool concatenates everything in a single row as opposed to multiple rows.

Current Result

710,1970,4,2,1971,4,2,1972,5,3,1973,5,2,1974,5,2

Expected Result

Request_ID	ID_Int	Line_Int	Workflow_Int	Expected Result
710	1970	4	2	710,1970,4,2
710	1971	4	2	710,1971,4,2
710	1972	5	3	710,1972,5,3
710	1973	5	2	710,1973,5,2
710	1974	5	2	710,1974,5,2

Also, in my actual data, I have hundreds of rows and columns so I am trying to figure out the most efficient way to do it without manually concatenating each row. 

Appreciate if anyone can point me in a right direction.

[seven · Accepted solution]

Hi,

the trick is to use a RecordID and join back.

[grazitti_sapna · Accepted solution]

HI @jannet2014 , PFA the workflow for the desired output.

Thanks.