Problem with my IF statement - Ends up overwriting existing values

[himam]

Hey guys, I am running an IF statement using Formula step and it is overwriting existing values. Basically I have a table that looks like the following

PTR LOB Seg_1	PTR LOB Seg_2	Segment2
PL	Chk Pol
PL	Runoff
PL	RO
Land	AT	A
Building	AB	A

my desired result is what you see in the table below and I am using the formula

DESIRED RESULT

PTR LOB Seg_1	PTR LOB Seg_2	Segment2
PL	Chk Pol	Exclude
PL	Runoff	Exclude
PL	RO
Land	AT	A
Building	AB	A

FORMULA USED

Instead I end up getting the following table, as you can see it ends up overwriting .

PTR LOB Seg_1	PTR LOB Seg_2	Segment2
PL	Chk Pol	Exclude
PL	Runoff	Exclude
PL	RO	Exclude
Land	AT	Exclude
Building	AB	Exclude

Can you please advise me on what I need to fix? Thanks in advance!

[ShankerV]

Hi @himam 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @himam 

Amended Formula:

Many thanks

Shanker V

[binuacs]

@himam another way of doing this with the IIF statement and IN operator

IIF([PTR LOB Seg_1] = 'PL' AND [PTR LOB Seg_2] IN ('Chk Pol','Runoff'),'Exclude',[Segment2])