Prioritizing Loan Number Retrieval Based on Data Presence

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

Pipeline_NULL.xlsx

Pipeline.xlsx

Workflow

Common Use Cases

Preparation

Accepted answers

KamenRider

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

All comments

Gaurav_Dhama_

Can you provide a sample output?

KamenRider

Hi Alteryx community, @Gaurav_Dhama_

Output for Loan number without data

No Loans Output.PNG

Output for Loan number with data

With Loans Output.PNG

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

Hi @Qiu @Gaurav_Dhama_

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.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335