WHEN "pear" THEN "pearbanana"
WHEN "banana" THEN "pearbanana"
WHEN "carrot" THEN "carrotpineapple"
WHEN "pineapple" THEN "carrotpineapple"
If you goal is to eliminate the IDs with different strings then this will work
place it on the filter shelf and set to true
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Your ID is not a unique. So It had concatenated both the string which is having same ID.
Thank you for your answer. However I have a lot of data, and this was just an example. So your solutions is not working in this case.
Thank you, Jim.
I might have communicated my problem not well.
I dont want to filter IDs with different strings.
I want to combine, for every ID, all the strings. Then I need to filter for two specific combined strings.
Do you have a solution for this scenario as well?