Find & Replace variable string counts

MNewt9

All,

While performing a workflow I am able to identify a series of reference numbers that have a missing cost in the price field.  I have a query to a database that can locate the cost (assuming there is a valid cost populated) based on reference number or date range.  After identifying the reference numbers with missing cost regardless of count (sometimes 5, others 20, or even 100, etc.) I would like to perform a find and replace using the secondary query to locate the cost regardless of the reference # count.  

Example:  Workflow identified 13 reference numbers with no cost in the price field.  Secondary query locates the missing cost.  Find and replace in original workflow the null values with the cost.  Next reporting period there are 38 w/ no cost.

Thanks in advance.

Mike

MNewt9

So simple.  I guess I was overthinking it.

This should work regardless of my null value counts from initial WF.

I'm only a couple months into Alteryx.

Thank you sir.