topic GUID values don't always contain brackets in QlikView https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735656#M263251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my model i'm linking two sets of records together by GUID values and in some cases they have the curly brackets ( {..} ) and sometimes they dont. This is making the joins difficult and means i'm not getting the data i'm expecting.</P><P></P><P>Can someone help me understand why this is happening, and how to fix it?</P></BODY></HTML> Tue, 24 Jun 2014 12:56:21 GMT 2014-06-24T12:56:21Z GUID values don't always contain brackets https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735656#M263251 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my model i'm linking two sets of records together by GUID values and in some cases they have the curly brackets ( {..} ) and sometimes they dont. This is making the joins difficult and means i'm not getting the data i'm expecting.</P><P></P><P>Can someone help me understand why this is happening, and how to fix it?</P></BODY></HTML> Tue, 24 Jun 2014 12:56:21 GMT https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735656#M263251 2014-06-24T12:56:21Z Re: GUID values don't always contain brackets https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735657#M263252 <HTML><HEAD></HEAD><BODY><P>I have no idea why your data sources contain guids with and without curly brackets. What you can do is always remove the curly brackets in the script by using the purgechar function:</P><P>purgechar(MyGuid, '{}') as MyGuid</P></BODY></HTML> Tue, 24 Jun 2014 12:58:49 GMT https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735657#M263252 Gysbert_Wassenaar 2014-06-24T12:58:49Z Re: GUID values don't always contain brackets https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735658#M263253 <HTML><HEAD></HEAD><BODY><P>I found out that the reason why some had brackets and some not was due to the type of database connection I had, with the ODBC type removing them as it processes the data types.</P><P></P><P>Thank you for the purgechar function though, I was not aware of it and i'm sure that it'll come in useful in the future</P></BODY></HTML> Wed, 25 Jun 2014 10:43:35 GMT https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735658#M263253 2014-06-25T10:43:35Z Re: GUID values don't always contain brackets https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735659#M263254 <HTML><HEAD></HEAD><BODY><P>Hello, I have same problem.</P><P>How do you manage it whith different connections?</P></BODY></HTML> Fri, 07 Aug 2015 11:19:24 GMT https://community.qlik.com/t5/QlikView/GUID-values-don-t-always-contain-brackets/m-p/735659#M263254 2015-08-07T11:19:24Z