ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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