Using Contains - Formula Tool

[suby]

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

[atcodedog05 · Accepted solution]

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.

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]

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]

Happy to help

Happy analyzing : )🙂

[suby]

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]

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

Its really going to help me : )

Always happy to help : )

Happy analyzing : )