Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Cross Tab with Multiple Column Headers

twheeler
7 - Meteor

I am fairly new to Alteryx, and I am trying to take a data set that looks like the below:

 

AcountAcct DescLegal EntityLE DescAmount
60000000SalesABC001ABC Company50000
60001000Sales - OtherABC001ABC Company30100
60000000SalesABC005ABC Limited75000
60001000Sales - OtherABC005ABC Limited25250

 

And change it to look like the following:

 

  ABC001ABC005
AcountAcct DescABC CompanyABC Limited
60000000Sales5000075000
60001000Sales - Other3010025250

 

I can use the cross-tab tool to get either Legal Entity or LE Description as the column header, but how do I get two columns, as shown?  Any help would be greatly appreciated.

11 REPLIES 11
twheeler
7 - Meteor

Hi Jim - I have attempted to run this with my entire data set now, and it appears to working great for the most part.  The only issue is that at the end, I still have some alignment issues with some of the entity codes showing over the acct description.  I can't understand why.  When I export each of the tables before the join, it looks like they are doing what they should be doing.  It is like the Join isn't joining by position.

 

Table 1:

 

Table 1.png

 

 

Table 2:

 

Table 2.png

 

 

Final Browse Tool:

 

Final Browse.png

ibvelaine
5 - Atom

Hi @Jim7  Would you be able to share a sample workflow that's compatible with Alteryx version 11 please?

I tried opening the workflow file you provided but i wasn't able to open it because my Alteryx has an older version :(

Labels