Update a field based on a condition without affecting non null values

[pranee_007]

I have two data sources. One contains bank account details (S1). Other contains transaction details (S2). I used a find and replace tool to append a new field and record its values to a field in S1 if there is a match between fields in S1 and S2. Now there are lot of null values in the newly created field.

Now I want to change the null value based on a condition which is if a particular field in S1 is "x" then new field should the null value to x and if not "y". But, I don't want non null values to be populated. I want only null values to change. Is there a way we can solve this?

[rafalolbert · Accepted solution]

Hi @pranee_007,

Please consider using 'Join' tool and joining on a common filed, 'account' in my example.

This method will allow you to carry forward any original fields in S1 and allow you to manipulate them following the join operation.

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[benakesh]

Hi @pranee_007 ,

s1 field  is [s1f]  and s2field is  [s2f ] 

Use this  formula  to change  null  s2f  after  find and replace   .

iif( [s1f] = 'x'   and  isnull([s2f]) , 'x' ,'y'  )