Forum Discussion

BahntjeRuben's avatar
BahntjeRuben
Regular Visitor
6 years ago
Solved

Column header and data in same row

I ve this type of records: date=2020-07-28 time=11:35:29 user="user001" msg="Some String With Spaces" logid=100 date=2020-07-28 time=9:15:10 user="user002" msg="Another Text" logid=102 date=2020...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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 🙂

    YouTube, LinkedIn


Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.