topic Re: Prioritizing Loan Number Retrieval Based on Data Presence in Alteryx Designer Desktop Discussions

Prioritizing Loan Number Retrieval Based on Data Presence

KamenRider — Mon, 18 Aug 2025 09:53:39 GMT

Hello Alteryx Community,

I'm looking for your help to extract data based on the Loan number field. If the field contains both data and null values, I need to retrieve only the loan numbers with actual values. Conversely, if the field is entirely null, I want to obtain those loan numbers with null values. This approach will enable me to prioritize retrieving loan numbers with data over those that are null.

Attached two sample files for your reference.

Looking forward for your response.

Thanks,

Kamen

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Gaurav_Dhama_ — Mon, 18 Aug 2025 10:21:38 GMT

Can you provide a sample output?

Re: Prioritizing Loan Number Retrieval Based on Data Presence

KamenRider — Mon, 18 Aug 2025 10:42:52 GMT

Hi Alteryx community, @Gaurav_Dhama_

Output for Loan number without data

Output for Loan number with data

Hope this helps.

Kamen

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Gaurav_Dhama_ — Mon, 18 Aug 2025 11:04:04 GMT

These are same as what you have attached in the post, what is the input data then?

So far it looks like just filtering scenario.

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Qiu — Tue, 19 Aug 2025 00:09:35 GMT

@KamenRider
@Gaurav_Dhama_
I am sorry that I had a butter finger and accepted the solution.

And I dont not understand the question either. 😁

Re: Prioritizing Loan Number Retrieval Based on Data Presence

KamenRider — Tue, 19 Aug 2025 05:42:13 GMT

Hi @Qiu @Gaurav_Dhama_

I believe it would be beneficial if you allowed me the opportunity to further elaborate on the scenario. Accepting a solution without a genuine resolution can be perplexing for those seeking answers to similar situations. It doesn't provide much assistance. Just some feedback.

Thank you for your time.

Kamen

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Gaurav_Dhama_ — Tue, 19 Aug 2025 06:06:07 GMT

I had removed the solution tag from my reply, let us know the scenario. What are the inputs and what are the outputs (are there multiple outputs, or just one etc.).

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Qiu — Tue, 19 Aug 2025 06:17:17 GMT

@KamenRider @Gaurav_Dhama_
I did not know we can unaccept the solution by Acceptee. 😁
Again . Sorry for the butter finger.

Re: Prioritizing Loan Number Retrieval Based on Data Presence

Qiu — Tue, 19 Aug 2025 06:17:19 GMT

@KamenRider @Gaurav_Dhama_
I did not know we can unaccept the solution by Acceptee. 😁
Again . Sorry for the butter finger.