Forum Discussion

TBenders's avatar
TBenders
Helper II
10 years ago
Solved

Combining rows based on unique id, and combining information

Hi,   This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi ImkeF 

I know. If you want i can show you the file.pbx. These duplicate values are the "Titles" i want to have for the columns. The thing is that if i eliminate those values from the column "Attribute",it also eliminates the row of the column "Value". Sorry for my english. I show you what i need to have:

LegajoEstilo PersonalÁrea de Mejora
145informationinformation
567informationinformation
456informationinformation
546informationinformation

 

And i show you what i have:

As you see, the information is a bit messed up. This is because it is import from pdf files which are interviews from employees.

I take your help to know if you know a better way to import files from this source (pdf files) since they complicate my work a lot.

Thanks in advance


Regards 

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Sorry, but I cannot find any clarification in you latest post.

Please keep your samples to the first 3 "Legajo"s: 154, 219 and 305:

 

 

  1.  What do they contain? (You can use the formula I've suggested, but don't have to. Otherwise just paste the raw data)
  2.  How do you want to visualize them?

The source of your data is irrelevant at this stage.

 

  • ImkeF's avatar
    ImkeF
    Community Champion
    7 years ago

    If you add 

    each Text.Combine(_, "#(lf)")

    as the 5th parameter to your Table.Pivot function, you'll get all the different rows combined with a line break in your pivot table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    The error occurs because the titles "Estilo Personal" and "Áreas de Mejora" appears several times. I show you the difference between the error and the rows OK:
    Before pivot:
    Error example: 503

    Example OK: 450


    As you can see the difference are the duplicates of the titles. But as i said if i eliminate them it will eliminate all the info of the column "Value"

     

    Thanks