Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.