Is there a way to manage the order of Columns and Rows for an Editable Table?

Situation

I'd like to use an Editable Table for gather business rules; as it would then be convenient to update when any new rules need to be added, or existing ones need to be amended. I intend to use this as a Rules Table for a Tablematch function in another table.

Requirement

However, using TableMatch formula requires that the column I would like to return is the last column, only then it would process the rules in the preceding columns. Further, in some cases, the row order maybe important as it determines which rule gets executed first.

Problem

When using Editable Table, and then creating a new Table based on that Editable Table, it seems to randomly generate a new order of both Rows and Columns. As a result the TableMatch formula does not process all the rules (ignores the tables to the right of the return column), and does not process in the designed order.

Is there a way to control this behaviour?

@Johann Malherbe�, @Vincent Jay, @John Adipietro, @Wendy Wang, @Jenny Goodwin, @James Kelliher

Can you tell if the new table's columns are truly in random order vs being sorted (alphabetically)? If sorted, you could try renaming them first to include some kind of indexing identifier as the first part of the column name.

Similarly, what I've seen other customers do to preserve row order is include a sequence number column which contains a manually generated row number. Then in the later table they would apply a sort step on that column, followed by a hide step if necessary.

@John Adipietro,

In my trial, I order set out in Editable table is:

The order in the resulting table is:

It's not Alphabetical, and I can't see any clear pattern either.

For Row Order - Row number idea sounds good for this ... but how do we apply a sort transformation to a table to preserve the row order? (I've only ever seen sorting being preserved when applied to tables on reports). 

Yeah you're right, I thought there was a Sort step for transforms, but there is not. I'll have to go back and look how the other customer was doing this again.

Could the column order be reverting to the original sequence? Or are you saying you defined a particular order from the start, and it does not respect that?

@John Adipietro,

I defined that particular order in the editable table to ensure the column that returns the value in TableMatch is last. It appears that way (as can be seen in the previous screenshot) as well.

But it somehow changes to a random order on the table based on this editable table. 

Sounds like strange behavior to me. It might be worth getting this into a support case so we can investigate further.

@John Adipietro and @Jaitabh Jewel Sharma, did you get the support case set up for this? Has the question been answered or is it still outstanding?

@Debbie Hagen ... in the interest of time, I amended by config, but I raised this buggy issue with our CSM @Johann Malherbe�. Just yesterday, he confirmed being able to repro it. He'll be raising this with the support team.

@Johann Malherbe� ... hope you'll keep us all updated here.

@Debbie Hagen ... the latest we heard from our CSM is that this is now with the Engineering team. Apparently, there is a JIRA ticket somewhere for this.

@Johann Malherbe� ... please keep us all updated on the progress with this issue.  

!SORT{column name}|asc]/

@Michelle McGuire ... how can one implement this on a table transform pipeline?

You do the sort in the editable table and then when you create the transform it will be in the correct order.  Here is a copy of the syntax that I used to sort on cost center.

In the editable table the configuration for Cost Center is

%BSC Cost Centers with Actuals/!LIMIT_COLUMNS[{Cost Center}]/!SORT[Cost Center|asc]

I hope that helps!  -m