Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have data in the format
INC | WKN |
INC123456 | 04-Mar-2023 11:58:32 - Firstname Lastname1 (Work notes)Monitoring the server.06-Mar-2023 07:49:24 - Firstname Lastname2 (Work notes)Promoted to a major incident.Waiting for Vendor. |
I'll have to split this data into
INC | Date-Time | Agent Name | Notes |
INC123456 | 04-Mar-2023 11:58:32 | Firstname Lastname1 | Monitoring the server. |
INC123456 | 06-Mar-2023 07:49:24 | Firstname Lastname2 | Promoted to a major incident. Waiting for Vendor. |
Please advise on how to achieve this
Thanks!
Hi,
you get this
by:
-split cloumn by delimiter to rows
- split column by delimiter (notice that the delimiter used is " - " with a space before and one after)
and finally split by delimiter
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
@serpiva64 - Thank you for the quick response
Usually, I'll have multiple statements within a single work notes
I think "." cannot be used as demiliter to rows
I have updated the sample table