Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
I am working with a log text file and I am having issues cleaning it up to provide meaningful data.
I am looking to put in seperate columns data between 2 events.
New entry always starts with text "Processing"
and entry ends with "Processed"
all rows inbetween are descriptions of what is happening between those 2 events.
example below
what I want is a report that will flag all items where "Pivot?" = 5
and details of the event around from that message.
I.e
all of this
I have tried pivot but becasue multiple events can occur at the same time as well as some events span across multiple minutes then I am getting errors of multiple items in one cell.
I had a version where I was able to flag errors that occured during the day but unable to get all information, only exact match to a time.