Basic Table Tool - How to change record order from Alphabetical to specified order

[Carluccio555]

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

[Felipe_Ribeir0]

Hi @Carluccio555 

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

.

.

.