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.
Can someone help me understand why this is happening, and how to fix it?
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:
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.
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
