Forum Discussion
Sort using the Sort by Column Button not Working
MattAllington is correct. It must be 1 to 1 relationship, which means it can only be one value for each entry in to column you want to sort. Otherwise, it will throw error message like below:
Regards,
Thanks for the info. However, I do not get any error message, the sort order simply does not change.
I am unclear as to why there would need to be a 1:1 relationship (or any relationship) when I am using a field within the table I am attempting to sort.
Are you simply trying to sort a table by one column or is there a reason you are trying to use the 'Sort by Column' function?
The first can be done simply by using the table header to sort the table.
The second is an option to sort a visual by a column on a reference table. As indicated, the reference table must have a 1:1 relationship with the data in the table you want to sort. This is used when you have a specific sort order that needs to be applied, inctead of a generic alphnumeric sequence.
What exactly are you trying to achieve?
I am trying to display the data in the natural order, rather than by one of the visible fields. Essentially, I want to sort the visible data by a field which exists in the same table but which I do not want to display.
Imagine my table has four fields. I want to display fields one, two and three in table form, but I want it to be sorted by the values in field four. Sorting by any of the three visible fields is unsuitable. In the transformation I have added an index column to provide the natural order value and it is this field I want to sort by, but not display.
According to the documentation, this should be possible:
OK, so you appear to want to use the function as intended. I know it seems a daft question, but have you checked the order of the column you want to sort by? If it is in the same order as the column you are trying to sort it almost certainly result in no change. Perhaps a sample of the 2 columns would help us identify the issue?