I am looking to create a field where if the field MARKET_PRICE has a value of 0 for Hospital2 through Hospital7, it replace the 0 value for that MARKET_SERVICE with the MARKET_PRICE of Hospital1. I know I can get the result I am looking for by creating a new table and loading the data for the Hospital and LEFT JOINING back to my table. But I wanted to find out of there is a formula I can use in my script to pull in the value without doing a second load of the data. I have attached an Excel sample of the data and the result I am looking for.
