Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

PuffinPanic
9 - Comet

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 

PuffinPanic_0-1678202412833.png

to 

PuffinPanic_1-1678202425315.png

but what I'm getting is

PuffinPanic_2-1678202483883.png

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

PuffinPanic_3-1678202535123.png

 

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

1 REPLY 1
PuffinPanic
9 - Comet

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

Labels