I have a spreadsheet input file that I am trying to manipulate in the load script. In the below script portion, I need to use the [Agency Name] as is or conditionally generate two new values being 'Cancelled Shift' or 'CL' respectively.
IF ([External Agency] <> ' ' and ([Request Status] = 'Not Fillable'), 'Cancelled Shift',[External Agency]) as [External Agency],
IF ([External Agency] = ' ' and ([Request Status] = 'Filled'), 'CL',[External Agency]),
as written, the first IF statement is executed correctly but the second IF statement is ignored. Any help would be much appreciated.
