Forum Discussion

craig811's avatar
craig811
Icon for Helper III rankHelper III
5 years ago
Solved

Best way to transform Oracle standard reports

Hi,

 

I would like to re-format some of the standard Oracle report output into a more readable format. I can then also use them in my Power BI model.

 

However, when I try and split the data using Power Query it does not offer a fixed width option like Excel.

 

What would the best option? I have used 'Space' delimiter, however it then splits data across more then one column.

 

Thank you in adavnce 

  • craig811 

    Use the following option in Power Query

     

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     

1 Reply

  • craig811 

    Use the following option in Power Query

     

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn