Forum Discussion
Helper IICombining rows based on unique id, and combining information
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
Community ChampionHi 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.
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:
| Legajo | Estilo Personal | Área de Mejora |
| 145 | information | information |
| 567 | information | information |
| 456 | information | information |
| 546 | information | information |
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