Data Types on keys (numbers with leading zeros)

steasy — Fri, 25 Aug 2023 14:11:50 GMT

Hi,

I did some transformations and realized that my keys won't match. For example

Table Colors

Key	Value
00153	Green

Table Numbers:

Key	Value
00153	Seven

I literally can see in my tables, that in table Colors the Key always is left-aligned why the Key in table Numbers always is right-aligned. Probably a data type problem with strings and integers?

What are the two ways to make them both strings oder both integers? Both of them have leading zeros.

Thanks in advance!

Re: Data Types on keys (numbers with leading zeros)

Digvijay_Singh — Fri, 25 Aug 2023 14:41:58 GMT

I think make the numeric one as text if its not hurting the performance etc using text() function -

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterpretationFunctions/Text.htm

Or try Num() or Num#() to make both as numbers

topic Re: Data Types on keys (numbers with leading zeros) in App Development

Data Types on keys (numbers with leading zeros)

Re: Data Types on keys (numbers with leading zeros)