Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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