Joins with numeric(28,0) fields

[Anonymous]

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

[sunny_talwar]

See if this helps:

Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. T...