Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use an If statement in my script to change values in my "Active" column from 'No' to 1 and "yes" to zero.
Been trying but I must be doing something wrong.
Thanks!
LOAD "User_ID",
"User_Name",
"First_Name",
"Last_Name",
(Inactive) as Active,
SSO,
1 as MFCount,
if((Inactive) ='No',1,0) AS ActiveFlag;
SQL SELECT * FROM IDONTKNOWWHAT;
Hi,
Check with this
LOAD
"User_ID",
"User_Name",
"First_Name",
"Last_Name",
(Inactive) as Active,
SSO,
1 as MFCount,
Pick(MixMatch(Trim(Inactive), 'Yes', 'No'), 1, 0) AS ActiveFlag;
I got it to work. Thank you very much for you patience! I'm new at this!