Here comes a case with multiple datatables.
Datatable 1 only with columns: “Staff ID”, “Staff Name”, “Passport”
Datatable 2 only with columns: “Amount”, “Category”, “Follow-up”
Now I want to merge the findings of the above datatables to a new output table.
The columns order of new table must be as below:
Since the column order changes and some cells are null, would anyone suggest some ways to write the above datatable?