Filtering out similar data from 2 different column

[Glenlim]

Hi, 

Can anyone help me with this issue below?

I have been trying to filter out similar data from 2 different columns (below). I've tried using the Unique tool but it's not pulling out any similar data. 

I've also tried using the Formula tool  but doesn't work either. 

[kamal03]

Is it possible for you to share sample dataset ?

[Peachyco]

Are you trying to find the values that exist in both columns, regardless of whether or not they actually exist in the same row? Something like this can work:

It starts like this:

And ends up like this:

 

[Glenlim]

Hi, 

please find attached the sample data.

Thanks

[Glenlim]

Tried your method but doesn't seem to be giving me anything in the join output. 

[Deano478]

Hey @Glenlim can you define what you mean by similar in this context?

[Glenlim]

Apologise if I am not clear enough.

I want to find out which data from Thinkfolio column appears in the Trade data column. 

[Deano478]

@Glenlim You can try something simple like this to see what is common in both:

[Glenlim]

Hi, 

do you mind posting as a photo as I am not able to download it. 

Thanks

[grazitti_sapna · Accepted solution]

Hi@Glenlim 
One simple approach to address this issue involves utilizing the join tool. If the data includes redundancies, consider removing duplicates before applying the join. Please find the solution below, which covers both scenarios — with duplicates and without.

If it works Kindly accept it as Solution.

Thanks