Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Using Contains - Formula Tool

suby
Bolide

Hi All,

 

I'm struggling to get the Desired Output when I use the Contains function using Formula tool.

 

See the attached workflow and attached Image which gives you the current result and the expected result.

 

Thanks

5 ANTWORTEN 5
atcodedog05
22 - Nova
22 - Nova

Hi @suby ,

 

Great scenario

 

By default join tool sorts the ID and Max_test by ascending and unique is tool is keeping only the first occurrence.

Hence record with Max_test 1 is filtered out.

 

By dragging a sort tool and sorting Max_test by descending before unique tool will provide the desired result.

Refer below. Workflow is also attached.

 

atcodedog05_0-1587218341417.png

 

I hope that was helpful.

 

Please support the community by liking and accepting my post as solution if it solves your issue.

 

Thank you for sharing this scenario. It was a great exposure.

Happy Analyzing : )

 

suby
Bolide

Hi,

 

You've made my day it was a great solution and I really appreciate your quick response.

 

You're Amazing... Thank You Thank you so Much..

atcodedog05
22 - Nova
22 - Nova

Happy to help

 

Happy analyzing : )🙂

 

 

suby
Bolide

Thanks Much appreciated and it was really a quick one.

 

I've been struggling for the past two days and I couldn't figure it out but your solution worked like a charm.

 

Amazing I owe you a drink..

atcodedog05
22 - Nova
22 - Nova

Maybe instead you can like all my replies for this post.

 

Its really going to help me : )

 

Always happy to help : )

 

Happy analyzing : )

Beschriftungen
Top-Lösungs-Autoren