topic Associated Tables in QlikView

Associated Tables

Mon, 15 Jun 2015 08:03:04 GMT

I want to make one tables from two tables.

in document, employee tables have one column but this just example if I want to add 3 or more column Order tables ,How can do it?

LOAD EmpID as EmployeeID ,

EmployeeName,

Example1,

Example2,

FROM

[..\egitim\EndUser\Employee.xls]

(biff, embedded labels, table is Employees$);

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity,

EmployeeName,

Example1,

Example2,

FROM

[..\egitim\EndUser\Sales.xls]

(biff, embedded labels, table is Orders$);

Thanks.

Re: Associated Tables

MK_QSL — Mon, 15 Jun 2015 08:35:25 GMT

Question itself is not clear... !

Could you please provide some more information about your requirements?

Re: Associated Tables

Mon, 15 Jun 2015 08:41:32 GMT

I have two tables and I know associated these tables

LOAD EmpID as EmployeeID ,

EmployeeName,

Example1,

Example2,

FROM

[..\egitim\EndUser\Employee.xls]

(biff, embedded labels, table is Employees$);

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity,

FROM

[..\egitim\EndUser\Sales.xls]

(biff, embedded labels, table is Orders$);

These tables, I want to this style ->

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity,

EmployeeName,

Example1,

Example2,

;

Re: Associated Tables

sunilkumarqv — Mon, 15 Jun 2015 08:48:46 GMT

Use joins :

try like below

Sales:

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity

FROM

[..\egitim\EndUser\Sales.xls]

(biff, embedded labels, table is Orders$);

Left Join(Sales)

Emp:

LOAD EmpID as EmployeeID ,

EmployeeName

FROM

[..\egitim\EndUser\Employee.xls]

(biff, embedded labels, table is Employees$);

Re: Associated Tables

PrashantSangle — Mon, 15 Jun 2015 09:05:56 GMT

Hi,

Use Join in two table definations.

try like

Load * from table1;

Join

Load * from table2;

Regards

Re: Associated Tables

Mon, 15 Jun 2015 09:10:22 GMT

Can I use Resident Load?

Re: Associated Tables

PrashantSangle — Mon, 15 Jun 2015 09:11:54 GMT

Hi,

Yes You can

but why you want???

Regards

Re: Associated Tables

Mon, 15 Jun 2015 09:18:34 GMT

Hi,

Actually,I want to make one tables from other tables's column. For examle;

LOAD EmpID as EmployeeID ,

EmployeeName,

Example1,

Example2,

FROM

[..\egitim\EndUser\Employee.xls]

(biff, embedded labels, table is Employees$);

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity,

FROM

[..\egitim\EndUser\Sales.xls]

(biff, embedded labels, table is Orders$);

New TABLE:

LOAD Product,

CustomerID,

EmployeeID,

EmployeeName,

Example1,

Example4,--other tables

I create new tables from other tables.

Thanks you for your interes

Re: Associated Tables

PrashantSangle — Mon, 15 Jun 2015 09:35:27 GMT

Hi,

Ok, I got you requirement.

Yes you can acheive it through Resident Load but rename the fields to avoid unwanted Key(Synthetic key)

and close the thread if issue resolved.

Regards,