topic One to one relationship in Connectivity & Data Prep

One to one relationship

vijendra_t — Tue, 28 Dec 2021 19:31:10 GMT

Hello Qlik^ers...

Please help me to understand relationship: 1 to 1, 1 to Many, Many to Many

Sample Script:

Table1[

LOAD
OrderID,
LineNo,
ShipperID,
CustomerID,
ProductID,
EmployeeID,
ShipmentDate

FROM anc.qvd

]

Table2:[

LOAD
OrderID,
LineNo,
ProductID,
Quantity,
UnitPrice,
Discount
FROM bbc.qvd

]

Re: One to one relationship

Yoshidaqlik — Thu, 05 Sep 2019 11:14:16 GMT

Hi,

I will try to use some examples

1 to 1

would be a relationship where there is only one possible binding for each record in two tables

Employees: Load Employees_ID, Name From Employees_Table; Current_wage: Load Employees_ID, Current_wage From Current_wage_Table;

1 to Many

When there is a possible link in one table that can be linked to several records in another table

Sales: Load Sales_ID, Employees_ID, Value From Sales_Table; Employees: Load Employees_ID, Name From Employees_Table;

many to many

when there are many result records that can link between two tables

Sales: Load Sales_ID, Employees_ID, Value From Sales_Table; Commission_history: Load Employees_ID, Commission, Date_Month From Commission_history_Table;

Regards

Re: One to one relationship

vijendra_t — Thu, 05 Sep 2019 13:54:28 GMT

Thank you for help.

But I need help regarding Scripting.

Can you help me Understand that.

Thanks again