topic Re: Join two fields with different data types in QlikView

Join two fields with different data types

master_student — Thu, 30 Jun 2016 22:29:01 GMT

Hi guys,

if i have 2 tables linked by a field A but those fields haven't the same data type, field A in table 1 is varchar and the other is a number. it affects the join or not?

Thanks

Re: Join two fields with different data types

vikramv — Thu, 30 Jun 2016 22:39:43 GMT

They would just be force concatenated.Take a look ate the below example.

LOAD * INLINE [

A, B

1, 4

2, 5

3, 6

];

LOAD * INLINE [

A, D

a, 1

b, 2

c, 3

];

Output:

When we create a table box using Table A and B :

A	B	D
a	-	1
b	-	2
c	-	3
1	4	-
2	5	-
3	6	-

Re: Join two fields with different data types

sunny_talwar — Thu, 30 Jun 2016 22:50:48 GMT

Can you share the kind of data you have?

Re: Join two fields with different data types

johnw — Thu, 30 Jun 2016 22:54:23 GMT

It does affect the join, yes. Just convert one of the fields to match the other when reading them in. If you want them to be text, then do this when loading the table where it's a number:

text(A) as A

Or if you want them to be numbers, do this when loading the table where it's text:

num(A) as A

Re: Join two fields with different data types

master_student — Fri, 01 Jul 2016 07:51:35 GMT

Thanks John.