Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor II

Join the two tables without common field

I have two tables T1 & T2. there is no common field between the tables. I want join these two table. How can i do It?

2 Replies
Highlighted
sibusiso90
Contributor II

Re: Join the two tables without common field

Based on your need you can either concatenate your tables and make it one table or when you just join with no common field its joining to create duplicated information.

eg

T1:

no,type

1,a

2,b

3,c

T1:

date,name

23/13,sipho

12/18,kate

Joined table:

no,type,date,name

1,a,23/13,sipho

2,b,23/13,sipho

3,c,23/13,sipho

1,a12/18,kate

2,b,12/18,kate

3,c,12/18,kate

Partner
Partner

Re: Join the two tables without common field

You can still join the tables with LEFT JOIN (T1) LOAD * FROM T2. But you will get a cross join. Basically every field is joined with every possible field value the other table. So this can be a usefull technique if you know what you're doing. But it also can cost a lot of GB RAM and makes your computer stop working.