How can I sort order row output result with NULL values

[mathias_schnoor]

Hey!

I have given this output result:

And I want this output result if possible:

Do you no any solution for this output result?

Mathias

[MarqueeCrew]

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.

[Joe_Lipski · Accepted solution]

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

[MarqueeCrew]

Looks like we had the same idea.

[mathias_schnoor]

Thank you for your support.

It works!

Mathias

[tom_montpool]

Here's how I would approach it:

[Joe_Lipski]

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

[mathias_schnoor]

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