Forum Discussion

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

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 ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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 Yu

  • gpiero's avatar
    gpiero
    Icon for Skilled Sharer rankSkilled Sharer
    9 years ago

    v-qiuyu-msft

     

     

    Hi

    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