Aggregate the data in one line

[ivoiculescu2020]

Hello everyone,

Can you please help me with the following case? We have this set of data - screenshot is attached, I need all the information to be on one line and I don't know which tool/function in Alteryx to use: currently I have 3 lines of data with the same creator and approver but I don't know how to put the data in one line

Any help you can provide is welcome and appreciated!

Thank you!

[davidskaife · Accepted solution]

Hi @ivoiculescu2020 

One way of doing it, using this exact set of data, would be with the Summerize tool. Group by the columns that contain all data (i.e Job name, job started on etc) and Max the others:

you'd need to tidy up the column names on the output but will work for this specific use case.

If your data contains many rows like this, that need aggregating, but with different values, you'll have to find a way to identify which rows need grouping on as the Max functions won't work correctly otherwise.

[ivoiculescu2020]

@davidskaife 

Hello,

Thank you so much!! it worked!! :)

Have a great day!