Forum Discussion
Post PatronSorting Error: Can't be more than one value in 'x' for the same value in 'y'
IanCockcroft If it is not possible to ensure unique values in the 'Index' column, consider sorting the 'Line Item' column by a different column that does have unique values.
If you need to maintain the current structure, you can create a composite key by combining multiple columns to ensure uniqueness. For example, you can concatenate the 'Line Item' and 'Index' columns to create a new column with unique values.
CompositeKey = CONCATENATE([Line Item], [Index])
Then, you can sort the 'Line Item' column by this new 'CompositeKey' column.
Super UserIanCockcroft If it is not possible to ensure unique values in the 'Index' column, consider sorting the 'Line Item' column by a different column that does have unique values.
If you need to maintain the current structure, you can create a composite key by combining multiple columns to ensure uniqueness. For example, you can concatenate the 'Line Item' and 'Index' columns to create a new column with unique values.
CompositeKey = CONCATENATE([Line Item], [Index])
Then, you can sort the 'Line Item' column by this new 'CompositeKey' column.
Post PatronThanks Bhanu, that worked, but with a slight change
I got a circlar loop refernce initially if I use the column i want to sort in the CONCATE.
I used "a"
this doesnt make sence
i think its a bug