We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Deleting null values and aligning columns

JohnO
7 - Meteor

I'm having an issue where I need to filter out null values and then reposition and consolidate the remaining data.

 

The input looks like this:

JohnO_0-1661874968324.png

 

And I want the output to look like this:

JohnO_1-1661875012436.png

Is there a way to accomplish this?

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @JohnO 

 

I'd use the transpose and crosstab tools to help with this. This solution should work for any number of columns

 

Luke_C_0-1661875485786.png

 

 

JohnO
7 - Meteor

@Luke_C  Thank you! I'm not too familiar with the Tile tool, but I'll learn about it now

Luke_C
17 - Castor
17 - Castor

No problem! I'm basically using the tile tool to do a record ID for each column1 value. This helps to make the column headers in the final output consistent. 

Labels
Top Solution Authors