Problem with my IF statement - Ends up overwriting existing values

Question

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_2Segment2PLChk Pol PLRunoff PLRO LandATABuildingABA

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_2Segment2PLChk PolExcludePLRunoffExcludePLRO LandATABuildingABA

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_2Segment2PLChk PolExcludePLRunoffExcludePLROExcludeLandATExcludeBuildingABExclude

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

binu_acs · Answer

@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])

ShankerV · Answer

Hi @himam

Amended Formula:

Many thanks

Shanker V

ShankerV · Answer

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

Problem with my IF statement - Ends up overwriting existing values.yxmd