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


Fowmy's avatar
Fowmy
Super User
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