I ve this type of records:date=2020-07-28 time=11:35:29 user="user001" msg="Some String With Spaces" logid=100date=2020-07-28 time=9:15:10 user="user002" msg="Another Text" logid=102
date=2020-07-27 time=10:55:23 user="user001" msg="The quick brown" logid=105I want to split first line, and use the text before the = sign as headers and then split every row and use the text after the = sign as data. This is the expected resultdate time user msg logid
2020-07-28 11:35:29 user001 Some String With Spaces 1002020-07-28 9:15:10 user002 Another Text 102
2020-07-28 10:55:23 user001 The quick brown 105Ane idea how to resolve this?
Go to Solution.
@BahntjeRuben I saved your data as a text file and imported to into PBI, and did the transformation. Please check the steps and codes. This is dynamics, any # of columns and rows will work
You can download the file: HERE
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
View solution in original post
Must be an easier way than this but you could use Power Query:
I'm presuming "date=2020-07-28 time=11:35:29 user="user001" msg="Some String With Spaces" logid=100" is in one cell? if so,
Split by delimited "="
Then split "time", "user", "msg" and "logid" by delimited by Right most "Space".
The just remove the redundant columns and rename the remaining.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.