Prioritizing Loan Number Retrieval Based on Data Presence

[KamenRider]

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

[Gaurav_Dhama_]

Can you provide a sample output?

[KamenRider]

Hi Alteryx community, @Gaurav_Dhama_ 

Output for Loan number without data

 

Output for Loan number with data

 

Hope this helps.

Kamen

[Gaurav_Dhama_]

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.

[Qiu]

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

And I dont not understand the question either. 😁

[KamenRider · Accepted solution]

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

[Gaurav_Dhama_]

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.).

[Qiu]

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

[Qiu]

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