Forum Discussion
Data shaping- source file txt with data in a multirows solution
I am trying to shape some data in a txt file.
Unfortunatly data to shape are available on 2-3 rows
I have tried several method but this is the best condition I've got.
To be honest I do no have any idea if is it possible to solve this issue using PBI or I should elaborate in a different way.
Thera are no other chance to get this output in a different format from ERP.
Thanks for any suggestion.
7 Replies
Can you post the original data in text form and what you are trying to achieve?
Hi,
thanks for you attention.
I'll send a link via PM.
I shaped severl files from ERP but this time I lost the battle :smileyvery-happy:
Hi gpiero,
In Power BI Query Editor, there are some features we can use to transform data. See: Common query tasks in Power BI Desktop
In your scenario, it would be better you can share the sample source data and expected results for our analysis.
Best Regards,
Qiuyun YuHi
below an exmple
https://app.box.com/s/5ejjty321ak1t5s3y8gcqb1dtn3k0txr
The txt contains only the headers justo to show what I got. Here we have the headers in 2 rows but the final layout could be 3 rows.
I will not prepare the final layout until I'll have some solution to apply.
I need to understand the method to shape this kind of file. At the end the method will works with any number of rows
This is my expectation:
row 1 "Materiale", "Testo breve Materiale", "Div", "Mag", "TMv", etc, etc...
and not like this (output at the moment)
row 1 "Materiale", "Testo breve Materiale", "Div"
row 2 "Mag", "TMv", etc, etc...
Thanks in advance
Hi gpiero,
You can take a look at below similar threads:
Power Query - import txt file with multiple lines per row - change to one row
Best Regards,
Qiuyun Yu
