Using Contains - Formula Tool
- RSS-Feed abonnieren
- Thema als neu kennzeichnen
- Thema als gelesen kennzeichnen
- Diesen Thema für aktuellen Benutzer floaten
- Lesezeichen
- Abonnieren
- Stummschalten
- Drucker-Anzeigeseite
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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
Gelöst! Gehe zu Lösung.
- Beschriftungen:
- Workflow
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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 : )
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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..
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
Happy to help
Happy analyzing : )🙂
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
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..
- Als neu kennzeichnen
- Lesezeichen
- Abonnieren
- Stummschalten
- RSS-Feed abonnieren
- Kennzeichnen
- Moderator informieren
Maybe instead you can like all my replies for this post.
Its really going to help me : )
Always happy to help : )
Happy analyzing : )