I am very new to QlikView and have been searching for a way to convert a GUID. In sql I have to convert it to a uniqueidentifier to get the correct value but QlikView will not allow me to add that to the LOAD sql statement. The below is a portion of my code. I have also tried CAST and that also throws and error.
What I get: CB1BFE06ADC74444B9729AA5FCF35096
What I need to get (and works in SQL): 06FE1BCB-C7AD-4444-B972-9AA5FCF35096
Please let me know of any suggestions! Thanks!
LOADDISTINCT nameasUserName ,displayName ,distinguishedNameasUserDN ,objectcategory ,objectGUID ,userAccountControl ,extensionattribute15 ,title ,lastLogon ; SQL select name , displayName, distinguishedName, objectcategory, objectGUID, userAccountControl,extensionattribute15, title , lastLogon , CONVERT(UNIQUEIDENTIFIER, ObjectGUId) as AD_GUID FROM 'LDAP://$(RootDse)' where name>'$(arg)'