find disinct strings across multiple columns

using the columns highlighted in green below as input, I want to create the blue columns as output, whereby I determine the number of distinct strings, and then list them. The first part [count distinct] is easy, but I am unable to find a way to do the latter, i.e. find the distinct strings across all the input columns, and list them. Any and all help greatly appreciated. thanks

Workflow

Datasets

Accepted answers

atcodedog05

Hi @Diarmuid

Edit: I had missed out few requirements. Updating my workflow.

Here is how you can do it.

Workflow:

Hope this helps : )

Strs.yxmd

All comments

atcodedog05

Hi @Diarmuid

Edit: I had missed out few requirements. Updating my workflow.

Here is how you can do it.

Workflow:

Hope this helps : )

Strs.yxmd

Christina_H

Here's my solution:

Distinct strings.yxmd

AngelosPachis

Hey @Diarmuid ,

Here's my take on it

If you are sure that you will always get 4 columns at your input, I think @Christina_H solution works better as it seems to be more subtle.

Best,

Angelos

example.yxmd

Diarmuid

fantastic, thanks a lot guys, especially for such a quick response. I wasn't aware of the unique tool, that was the missing piece of the puzzle. thanks again

atcodedog05

Happy to help : ) @Diarmuid

I would definitely suggest you to check others solutions too it will help you get different prespective 🙂

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703