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

Question

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 · Answer

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

ProductRecordIDProduct A1Product B2Product C3Product D4Product E5Product F6

.