Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose rows into columns

AlterIT
8 - Asteroid

I have a dataset with few dimensions and I am trying to transpose some of the rows into columns.. Each User ID may have an Acct # in System A or System B or in Both. I need to transpose these Acct #s so that they will be represented as Sys A Acct # and Sys B Acct# . Also wanted 2 Boolean fields which says whether  User ID has entry in Sys A or Sys B.


Tried few options with transpose and cross tab and could not get to work.

2 REPLIES 2
phottovy
13 - Pulsar
13 - Pulsar

@AlterIT I recommend treating the systems and account numbers as two different calculations. The attached workflow gets the desired result but it could probably use some dynamic column renaming.

KarolinaRoza
11 - Bolide

Hi @AlterIT 

Please find my solution, it should be fine for your needs.

 

Regards,

Karolina

 

Labels
Top Solution Authors