Re: Changing a variable in one table to an updated status in another table
Thanks Yuri! I think it worked, but I need to include all of the other fields in the table (alpha_tmp) below. The script below only gives me the lead_id and status_name. Do I need to change what I loaded in that last part?
LOAD LeadID as lead_id,
status_name as status_update,
status_date as status_date_update
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
if( NOT IsNull(status_update), status_update, status_name) as status_name