topic Re: Joining Disparate values in QlikView

Joining Disparate values

QFanatic — Mon, 28 Nov 2022 07:47:09 GMT

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 — Mon, 28 Nov 2022 10:11:49 GMT

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 — Mon, 28 Nov 2022 10:58:23 GMT

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 — Mon, 28 Nov 2022 11:41:16 GMT

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

QFanatic — Mon, 28 Nov 2022 13:34:19 GMT

Thank you Henric.