Hi Team,
I have 2 data table’s. First data table is having data and the columns are given below
Employee ID | Legal Name | Employee Status | Manager Level | Employee Group | Employee Subgroup |
---|---|---|---|---|---|
123 | A1 | Active | L1 | G1 | S1 |
124 | A2 | Active | L2 | G1 | S1 |
I need to move this data to another table and the columns of this table. This table will be blank
GEID, Legal Name, Employee Status, Effective Date
Where GEID = Employee ID, Legal Name = Legal Name, Employee Status = Employee Status, Effective Data = 30 June 2021(Default Value)
In Short, 3 columns can be copied among which 2 columns have same header another column have different header and 4th column to be added wit default values…
Please suggest