how to match the values in two columns?

[Abdelrahmanmahdy]

I want to filter the rows that contains [partical_packaging_key] value is equal to [Parent_partical_packaging_key]. you can see in the example below in the image the value P001001876. it is exist in first column in one time and 6 times in second column.

[nagakavyasri]

@Abdelrahmanmahdy Both the columns are not having same P001001876 values. So, when filtered no values are in the output.

[Abdelrahmanmahdy]

they have same value (P001001876) but not in the same row. that is why the filter is not giving what I need.

I need then all the rows if column 2 contains the same value in column 1.

[binuacs · Accepted solution]

@Abdelrahmanmahdy try the join tool