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 have de same problem. Some rows have error "There were too many elements in the enumeration to complete the operation."

I show you a picture of mi example. What do you need to help me?

 

Hope you can help Me

 

Regards

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Hi Anonymous ,

These errors mean that you're trying to bring data into one row where there's actually more than one value per pivoted column. So you have to make up your mind and decide what to do with these multipe values: Combine then into one or delete them, because there are errors, create a separater table ... whatever is appropriate for your specific case.

 

To visualize the problem, you can add the following code as the 5th parameter to your Table.Pivot-function:

 

each Text.Combine(_, "#(lf)Additional Item: ")

This will create a line feed and a starting phrase for every multiple item in these rows.

 

 

  • 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.

  • 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.

     

  • 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 

  • 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