Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below script loading data from two excel sheets. the "AD" table does not have the "HR_Active" field so once the two tables are joined there are a lot of Null values. I would like to replace all the Null Values in the HR_Active field with a value.
AD:
LOAD DisplayName, AccountExpirationDate, mail, EmployeeNumber, Description, Enabled,
extensionAttribute11 as WorkDayID, SamAccountName
FROM
[\\NACL60\users_kl\koczeja\QlikView Windows 10 Reports\Canada AD Review\CA01_AD_Export_3_14.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
HR:
LOAD [Employee ID] as WorkDayID, [Legacy Employee ID], Worker, [Legal Name], [Worker's Manager], [Job Title],
[Email - Work], HR_Active
FROM
[\\NACL60\users_kl\koczeja\QlikView Windows 10 Reports\Canada AD Review\Employee_List_-_HR (56).xlsx]
(ooxml, embedded labels, table is [Employee List - HR]);