I am bringing data together from 2 sources (a dialler and dynamics CRM)
In the dialler a GUID was split into 2 fields as it was too long so I have used
CONCAT(`CALL_DATA1`,`CALL_DATA2`) as GUID,
to bring them together and use as the matching key in dynamics CRM.
The problem I have is that some records are matching and some are not - when I look at the non matching in Dynamics the GUID is the same as the concatenated field in Qlikview but the information wont show.
Is this a conversion issue and if so could anyone help with it?
///$tab Main SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='£#,##0.00;-£#,##0.00'; SET TimeFormat='hh:mm:ss'; SET DateFormat='DD/MM/YYYY'; SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';