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

How can I sort order row output result with NULL values

mathias_schnoor
11 - Bolide

Hey!

 

I have given this output result:

sort_row_given

 

 

And I want this output result if possible:

required

 

Do you no any solution for this output result?

 

Mathias

7 REPLIES 7
MarqueeCrew
20 - Arcturus
20 - Arcturus

If the incoming records were SELECTED and individually sorted, then your could take both streams of data into a JOIN (join on record position) and create that data.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Joe_Lipski
13 - Pulsar
13 - Pulsar

@mathias_schnoor Attached is one possible solution, there will be a few other ways that you could do this, depending on the exact scenario.

 

join.JPG

Joe Lipski
MarqueeCrew
20 - Arcturus
20 - Arcturus

Looks like we had the same idea.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
mathias_schnoor
11 - Bolide

Thank you for your support.

It works!

 

Mathias

tom_montpool
12 - Quasar

Here's how I would approach it:

LatLong_Join_with_Nulls.JPG

Joe_Lipski
13 - Pulsar
13 - Pulsar

We must have written at the same time @MarqueeCrew

 

Glad it worked @mathias_schnoor 

 

Could you please accept successful responses as a solution and star good responses as it helps everyone on the community if they have a similar question, as per point 3 of community guidelines: http://community.alteryx.com/t5/Welcome-to-the-Alteryx-Community/Alteryx-Community-Guidelines/m-p/6#...

 

 

Thanks,

Joe

 

Smiley Happy

Joe Lipski
mathias_schnoor
11 - Bolide

Hey Joe, Tom!

 

Thank you for your support.

The solution of Joe is the best solution for me, because any NULL values are in the result list.

 

Best regards

Mathias

Labels