I am fairly new to Alteryx, and I am trying to take a data set that looks like the below:
Acount | Acct Desc | Legal Entity | LE Desc | Amount |
60000000 | Sales | ABC001 | ABC Company | 50000 |
60001000 | Sales - Other | ABC001 | ABC Company | 30100 |
60000000 | Sales | ABC005 | ABC Limited | 75000 |
60001000 | Sales - Other | ABC005 | ABC Limited | 25250 |
And change it to look like the following:
ABC001 | ABC005 | ||
Acount | Acct Desc | ABC Company | ABC Limited |
60000000 | Sales | 50000 | 75000 |
60001000 | Sales - Other | 30100 | 25250 |
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.
Solved! Go to Solution.
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 2:
Final Browse Tool:
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 :(