Associated Tables

[#1]

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.

[MK_QSL]

Question itself is not clear... !

Could you please provide some more information about your requirements?

[#3]

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,

*

;

[sunilkumarqv]

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$);

[PrashantSangle · Accepted solution]

Hi,

Use Join in two table definations.

try like

Load * from table1;

Join

Load * from table2;

Regards

[#6]

Can I use Resident Load?

[PrashantSangle]

Hi,

Yes You can

but why you want???

Regards

[#8]

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

[PrashantSangle]

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,