Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Union not setting specific output order properly.

wonka1234
10 - Fireball
‎08-18-2023 08:46 AM

Hi,

 

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

 

However it is not,

 

Please see attached.

datecolumn ordering_union.yxzp
Labels:
Reply
0 Likes
6 REPLIES 6
lbardoe
8 - Asteroid
‎08-18-2023 08:51 AM

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

Reply
0 Likes
wonka1234
10 - Fireball
‎08-18-2023 08:53 AM

 

@lbardoe 

 

TRying to acheieve this result.

 

 

File_Name20221031202211etcetcetcRecord IdAccount
Reply
0 Likes
lbardoe
8 - Asteroid
‎08-18-2023 09:04 AM

Is this what you are after

datecolumn ordering_union.yxmd
Reply
0 Likes
wonka1234
10 - Fireball
‎08-18-2023 09:26 AM

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

Reply
0 Likes
cjaneczko
13 - Pulsar
‎08-18-2023 09:28 AM

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...

Reply
0 Likes
lbardoe
8 - Asteroid
‎08-18-2023 09:29 AM

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

Reply
0 Likes
Labels