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