Reporting - Table Tool - move multiple fields in per column configuration

[PuffinPanic]

Hi,

Does anyone know a way to move multiple field names in the 'Per Column Configuration' in the table tool? I want the fields to be in the order that they come into the tool from the upstream feed, but having added new fields (1 per supplier) these are all at the bottom of the per-column config in spite of being sorted with the other supplier specific columns in the select immediately upstream. 

When I added the new fields I expected my output to go from 

to 

but what I'm getting is

The fields are dynamically sorted upstream, so the order that they are in in the select immediately before the table looks like this

The only way I can find to move the 'Extra' field at the moment involves a lot of clicking in the per column configuration, which would be ok, if there were only going to be a couple of suppliers, but there are going to be 200+ and I need to make sure that the supplier fields are grouped together in the output.

Is there a way to force the table to to use the incoming order? Or am I missing something simple?

Any help would be appreciated.

Thanks

PuffinPanic

[PuffinPanic · Accepted solution]

I might have answered my own question. 

Removing and replacing the connection between the select and table tool forces the table tool to put the fields into the upstream order. 

I'd still be interested in knowing if there's a better way that anyone knows. In this case, I've got my table tool rules set up to apply to Dynamic or Unknown Fields, but I'm concerned that if I had rules/settings set for specific fields I'd have to reapply them all manually after breaking the connection.

PuffinPanic