Forum Discussion
Change row in multiple columns
Hi,
I need help to convert this data set. I need to make SessionID be a unique value. (At this time it is not) and that the DateTime and Event column must be associated with the SessionId only once. I want a single row for sessionID with a column for StartEvent, a column for EndEvent/ErrorEvent, and the corresponding timestamp in another one.
Let me give an example: each SessionID corresponds to an event of type "Start" and one of type "End" or "Error" and the corresponding timestamp. I tried doing a group by SessionId and using the unpivot function but the result is not what I wanted. Can you give me a hand please? I didn't find anything similar in the forum
Hi Margh9
Based on your description, I feel like you should try Pivot instead of Unpivot. From the screenshot, some SessionIDs may have multiple datetimes for an event. If you want to remain only one datetime of an event, you need to choose an appropriate aggregation function for the DateTime column.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
2 Replies
Hi Margh9
Based on your description, I feel like you should try Pivot instead of Unpivot. From the screenshot, some SessionIDs may have multiple datetimes for an event. If you want to remain only one datetime of an event, you need to choose an appropriate aggregation function for the DateTime column.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!- selimovd
Most Valuable Professional
Hey Margh9 ,
can you give an example how the result should look like?
I don't understand your description to be honest...
Also please share the data as table or better a PBIX file. If I want to re-create that case I will not type in the values from the screenshot...
Thank you and best regards
Denis
