How to write the range of a datatable in this troublesome case?

Hi Everyone!

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?

Many thanks.

  • use merge datatable activity
  • then reorder the columns (Filter DataTable Activity, DataTableVar.Select(…), SetOrdinal method

optional: mark the datatables on “From Which…” Column - e.g. datacolumn.Expression

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.