Creating a Table with a Set Order/Configuration

Question

I have a large data set that I have cleaned and put into a cross tab function to output the data with the correct x/y axis. However, I have had to add a "row order" field to sort it by at the end. This creates problems as sometimes, some divisions do not have any data. My goal is to be able to copy the excel output straight into my monthly KPI folder without having to go skip a few lines.

Is there a function to merge my output with the correct tables order?

I have attached a snip of what my cross tab output looks like before I sort by the row order field, and what I want my table to look like, even if I have a null row.

Table Order Wanted.PNG

Cross Tab Output.PNG

Bren_Spill2 · Accepted Answer

@Brittwisch -

1. Remove row order from your cross-tab output

2. Add Table Order Wanted to the workflow as a text input, then add a record ID. This acts as a standardized sort table

3. Join the text input + record ID to your cross-tab output on division, and union back the records from your sort table that didn't join to create the blank rows

4. Then sort by record ID and remove any unwanted columns with a select tool