Filtering out similar data from 2 different column

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.

Data set.png

Workflow

Datasets

Help

Database Connection

Accepted answers

grazitti_sapna

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

Filtering out similar data.yxzp

image (16).png

All comments

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: