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.

Capture 2.PNG

Output

Optimization

Accepted answers

@Abdelrahmanmahdy try the join tool

Parent_27112024.yxmd

All comments

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

Screenshot 2024-11-27 072714.png

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.

@Abdelrahmanmahdy try the join tool

Parent_27112024.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703