Joining Disparate values

[QFanatic]

Hi guys

I have 2 tables that both contain the field called 'employee_number'.

One table contains the value '0001234' and the other '1234' - Qlik Joins them...though its not the same employee at all.

 If they were both '0001234' I'd be happy that they join, but they're NOT equal.

How can I past this? Both tables come from MySQL data.

(May I add here that the '0001234' is the 'correct' value as it appears in the rest of our DB like that format).

Thanks

[hic]

The Qlik engine will assume that 0001234 and 1234 both are numeric, and hence the same. So, yes, they will be joined.

If you don't want to join them, you must force a non-numerical interpretation when you load them, e.g.

'EmpNo' & employee_number as employee_number,

Text(employee_number) as employee_number,

[QFanatic]

Hi Henric,

Thank you so much for your response.

"If you don't want to join them, you must force a non-numerical interpretation when you load them" - this goes for both values in both tables?

Thanks again

[hic · Accepted solution]

Correct. You must use the same definition in all tables where you have employee_number.

[QFanatic]

Thank you Henric.