same number as seperate dimensions

[thewillemzelluf]

Hello, I have concatenated different customer tables for an overview. This is because there are 2 tables in which customer '125' appears. However, it seems that the format of this is different because if I want to merge all the results, qliksense keeps seeing the same number as 2 separate dimensions. Could this be because a different format applies (num or text)?

Thanks in advance!

[dplr-rn · Accepted solution]

How are you merging the tables? concatenate?
from a high level type issue looks most likely reason. try num#(trim(yourfield))

i would try that and maybe diagnose it by loading the tables separatly and checking the data type on the model

[thewillemzelluf]

Thankyou! trim was enough! 🙂