Combine 2 fields with condition during data load

[sharon9]

Hi, still somewhat new to scripting.  I have a Status and Progress field which I need combine.  If Status = Approved, then replace status with Progress value.  I'd like to do this during data load.  

Status values:	Progress values:	So new Status field values would contain:
Approved On Hold Cancelled	Not Started Started Completed	Not Started Started Completed On Hold Cancelled

[rwunderlich · Accepted solution]

if(Status = 'Approved', Progress, Status) as Status

-Rob

[sharon9]

Thank you for validating what what I originally had.  I realized my script was breaking because I had two status field that were not unique....DOH!