Forum Discussion
Merge two tables, and update column header with data in specific column
Hi all, i have two tables Table 1 is about the allowances assign to specific designation Table 2 in emplyee payroll table i want to create a column with specific allowances an...
Hi,
You can use append queries on the basis of EmpID.
Not working.
- Hi Naushad123,
I think what you are after is the join/merge on the Designation field. Then expand Allowance types. Then pivot them.
The trick may be with pivoting if you want to make it dynamic on the allowance types included in the final dataset. If you need this let me know I will provide a solution -or you can do it yourself - this is an intersection of Table.ColumnNames on Table 2 and List.Distinct on Designation field in Table 1.
Kind regards,
JB