Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I need some Help...
I'm trying to join 2 tables via a numeric (20,0) field. However Qlik does not seem to like this.
it seems to conver the number as per below.
From: 5395072177213114882675115911
To: 5.3950721772131e+027
I've also tried chopping up the number using Left, Mid & Right as per below.
Left(PRIMARYATTACHMENTID,7)&'-'&Mid(PRIMARYATTACHMENTID,7,7)&'-'&Mid(PRIMARYATTACHMENTID,7,7)&'-'&Right(PRIMARYATTACHMENTID,7) as ATTACHMENTID
Any Ideas????
Thanks in Advance