I have set up my workflow to meticulously order every line of data ready to be reported in a table.
I now want to report this data in a specific non-alphabetical product order using a basic table, creating a record for each product using 'group by'.
The table outputs a record for each product but the order is alphabetical by product. How can I get the order I want?
Thanks
If you always have the same products, right before the table tool you could join your dataset with a text input that contain the expected order of types, and after the join, order by the RecordID
Product | RecordID |
Product A | 1 |
Product B | 2 |
Product C | 3 |
Product D | 4 |
Product E | 5 |
Product F | 6 |
.
.
.