Best way to transform Oracle standard reports

Question

Hi,&nbsp;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.&nbsp;However, when I try and split the data using Power Query it does not offer a fixed width option like Excel.&nbsp;What would the best option? I have used 'Space' delimiter, however it then splits data across more then one column.&nbsp;Thank you in adavnce&nbsp;

fowmy · Accepted Answer

craig811&nbsp;Use the following option in Power Query&nbsp;&nbsp;________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn&nbsp;

Forum Discussion

Related content

Table Transformation

Table Transformation

Report builder transformations

M Language Transformations

Eventhouse data transformation