In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Transpose then Join

cfrederes1
5 - Atom

Hi,

I'm attempting to make a 'flat' row by the field "TN" below- I can us the crosstab function and receive the output of the highlighted fields but I can't join to bring the correlated MRC and Qty field for every USOC.

 

INPUT:

input.jpg

 

DESIRED OUTPUT:

 

Desired Output.jpg

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@cfrederes1 
It can be completed with the combination of Transpose and Cross Tab and not that The duplicated fields names are not allowed.

1014-cfrederes1.png

Labels
Top Solution Authors