Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

markgraham123
Contributor II

joining with one to many relationship

Hi all,

Initially, there was many to many relationship between the tables.

after combining the columns it resulted in the below data model,

Can any one please lemme know is it good idea to join/left join/inner join these tables so as to form a single table.

Coz i wanna load then as a single table.

datamodel.PNG

Tags (1)
1 Reply
krishna_2644
Valued Contributor III

Re: joining with one to many relationship

These might help you in choosing your joins.

QV_Joins.png

Community Browser