Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Split column for specific value

Hello guys,   I would like to transform some values that markered in red from the column MESSAGE to a new columns TIMESTAMP and STATUS. Any suggestions to do that with PowerBI?     Kind regards!...
Need Help
Show and Tell
Tips and Tricks
  • Rfranca's avatar
    Rfranca
    8 years ago

    hi Anonymous

     

    This is easily resolved with EDITOR QUERY.

    For this you must use resources to split columns.
    1. Divide the time using the comma separator
    2. Divide the status using the seprador to '

    But beware of other data that follows the tab pattern for time and status.

    (see the sequence of images)

     

    Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

    Best Regards,
    Rfranca

     

     

     

Rfranca's avatar
Rfranca
Resolver IV
8 years ago

hi Anonymous

 

This is easily resolved with EDITOR QUERY.

For this you must use resources to split columns.
1. Divide the time using the comma separator
2. Divide the status using the seprador to '

But beware of other data that follows the tab pattern for time and status.

(see the sequence of images)

 

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca