This content has been marked as final. Show 3 replies
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!
name as UserName
,distinguishedName as UserDN
, displayName, distinguishedName, objectcategory, objectGUID, userAccountControl,extensionattribute15, title
, CONVERT(UNIQUEIDENTIFIER, ObjectGUId) as AD_GUID
and objectCategory = 'Person' ;