Value in column name_2 may not appear in any row in column name_1

Hello, recently I started working with easyMorph and I can’t figure out how to solve this issue.

I’l give an example:

A value in column name2 may not appear in column name_1

row name_1 name_2
1 A B
2 C D
3 B E

Value B appears in row 1 of column name_2 and appears also in row 3 of column name_1, which is not allowed.

This is what I would like to have as result:

row nr name_1 name_2
1 A Duplicate B
2 C D
3 B E

Can this be done in easymorph?

Thanks

Hi Peter and welcome to the Community,

Yes, it can be done in EasyMorph. See the project below:

column-duplicate.morph (3.3 KB)

Thanks for the solution Dmitry, it works just fine.

To learn more about EasyMorph visit easymorph.com.