Data Types on keys (numbers with leading zeros)

[steasy]

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!

[Digvijay_Singh · Accepted solution]

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/InterpretationF...

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