March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.