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

Can't seem to get this to fly. Trying to condense some columns..

Brad1
11 - Bolide

I need to get this:

 

Record_IdNtwk_ANtwk_BNtwk_C
1X  
2 X 
3  X

 

to look like this:

 

Record_IdNetwork_Id
1Ntwk_A
2Ntwk_B
3Ntwk_C

 

Surely, there is a simple way..  Thanks in advance.

11 REPLIES 11
patrick_digan
17 - Castor
17 - Castor

@Brad1 Try using a formula tool and using the max function:

Max(Ntwk_A,Ntwk_B,Ntwk_C)

EDIT: It helps if I read your post first :)  Try using a transpose, group by record_ID, and then a filter to get rid of the nulls.

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Brad1,

 

You can use a transpose tool, a filter and a crosstab to get you there....
Capture.PNG

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
JohnJPS
15 - Aurora

HI @Brad1,

Would the attached workflow work? Transpose and filter out the nulls?

Thanks,

John

 

[Edit: Wow, @patrick_digan and @MarqueeCrew are fast.]

Brad1
11 - Bolide

Maybe I'm not using the formula tool correctly.  Just upgraded to 11.0 today.  That formula gives me this:

 

Record_IdNtwk_ANtwk_B
1XX
2XX
3X

X

 

Just putting 2 Networks in the formula (to see what would happen) and not even filtering for anything besides Ntwk_A.

 

I'm sure I'm probably using the tool wrong.

MarqueeCrew
20 - Arcturus
20 - Arcturus

Please do try my workflow....

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Joe_Mako
12 - Quasar

Another potential route, if the fields are constant:

 

- Multi-Field Formula to replace non empty with Field Name
- Formula to Coalesce the values
- Select to remove the extra fields

 

coalesce.png

Brad1
11 - Bolide

I've been trying it for awhile with no luck.  Still trying..

Brad1
11 - Bolide

I did get it to work.  My issue was I clicked on either the transpose or cross tab tool b4 running.  doing that caused errors.  So I started tampering with it when I should have just hit play.  Thanks very much for your help.

Brad1
11 - Bolide

Thanks Joe.  I'm going to pull this down as well and see where we can put it to use.

Labels