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

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?

workflow.yxmd