Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Ordering header after removing null Column

MI1
7 - Meteor

I find the belwo workflow which work great - however I would like to order header based on the number of now empty row. can anyone help?

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-NULL-Columns-2019-4/m-p/755533/...

Remove null - works great ! original flow attached

MI1_0-1634301630779.png

 

Target - keep ordering after dynamic rename

MI1_1-1634301684726.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @MI1 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1634302881232.png

 

Hope this helps : )

 

MI1
7 - Meteor

@atcodedog05  The filter remove null column seems not working ?  as I still get some null column in the flow ?

MI1_0-1634307115669.png

 

Hence I put a filter after however not sure it is the optimum solution? as the process is relatively "Slow" now

MI1_1-1634307293003.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @MI1 

 

Add filter tool here. This method is processing more records hence is bit more slow.

 

atcodedog05_0-1634307540240.png

 

Hope this helps : )

Labels