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

Results.png

Sample Flow.yxmd

atcodedog05

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

Sample Flow.yxmd