Extract the value based on the conditions on rows

Hi Team,

I have a use case, where I want to populate a column with a value extracted from a condition on a row. Provided the example below for better comprehending.

Consider I have the below dataset

A. B. C

row 1 red 2

row 2 blue 4

row 3. purple 6

Now I want to create a column named "D" within the same dataset which should have the entire column filled with the value from the condition when (Column A == row2 and Column B == 'blue' then extract C)

The value from the above column (if (and (A == 'row2', B == 'blue'), C, ) is 4 so the column D should be filled with the value 4. While I write the above condition I have to provide the else case to replace the rest of the columns but I want to fill the entire column based only on 1 condition.

NOTE : I want to achieve this only using the visual recipes but not the coding recipe.

The output dataset should look like :

A. B. C D

row 1 red 2 4

row 2 blue 4 4

row 3. purple 6 4

Hoping to hearing from you soon !

Thanks !