Union not setting specific output order properly.

[wonka1234]

Hi,

I want to output my columns in order  3, 1, 2.

However it is not,

Please see attached.

[lbardoe]

Sorry not sure what you are asking here are you trying to transpose the Rows to Columns

[wonka1234]

@lbardoe 

TRying to acheieve this result.

File_Name

20221031

202211

etc

etc

etc

Record Id

Account

[lbardoe]

Is this what you are after

[wonka1234]

@lbardoe  not quite, as i wont know which columns to transpose. It could be dynamic.

[cjaneczko]

This appears to be related to your other post. See if the solution in the original post works.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Select-tool-ordering-of-fields...

[lbardoe]

Yeah that addition is dynamic if add additional data to your input and rerun it it should still work