Error expanding columns

Hi Dymension ,

 

When you expanded the new columns you have multiple results, so what happens is that each line from the original table is duplicated for those lines that are expanded.  From the error you are using a column from that table has part of a relationship on the one side.

 

For this you need to debug you table to check what is the repeated values, I would do a Group by on the column identified in the error and check wich ones are getting more than 1 value and the correct the data accordingly to your needs.