Association of tables

[Bharathi09]

Hi All,

I have 2 files

In old file there is only one sheet

In new file there are 2 sheets 

one sheet I have to merge and other sheet I need to load  do association with employee ID 

How to do association in data load editor?

[Lokesh_5045]

Old_File:
Load
EmployeeID,
Salary
From sheet 1;

New_File:
Coloumn1 as EmployeeID,
Coloumn2 as Salary
From sheet 1;

New_File2:
Column1 as EmployeeID,
Column3
Column4
From sheet 2;

Since Old_File table and New_File table have same field names, they merge together automatically and show table name as Old_File only.

New_File2 table has EmployeeID links with Old_File table automatically.

Note: If number of fields in Old_File and New_File tables are different, Use concatenate() after Old_File table.