We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose tool

Candykobli
7 - Meteor
‎11-10-2023 03:40 AM

Hi. 

I have this table.

 

GenderAvg_Age_FAvg_Age_M
M [Null] 65.351715
F 63.673591 [Null]

 

I would like to get this:

GenderAvg_Age
M65.351715
F63.673591

 

I can i do that with transpose?

 

Please, help me. 

Thank you

 

Marie

Labels:
Reply
0 Likes
3 REPLIES 3
TimN
13 - Pulsar
‎11-13-2023 08:26 AM

Does this help?

age.yxmd
Reply
0 Likes
CoG
14 - Magnetar
‎11-13-2023 09:59 AM

Simple Formula should suffice as well since one field or the other should always be Null

2023-11-13_11-58_Age.png

2023-11-13_11-58_Age.yxmd
Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎11-13-2023 03:01 PM

@Candykobli 
I would further add 2 more tools to the flow of @TimN to get the exact format as you specified.

1114-Candykobli.png

1114-Candykobli.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All