Merge two tables with different columns

Options
Jozef_783863
Jozef_783863 Posts: 331 admin
in Questions

Tables: Copy a table to another table only copies rows. How can you copy columns?

Would we need to use Tables: Apply formulas to columns to add one table next to another table?

While I investigate more, I would like to check if this building need has taken place in the past.

Best Answer

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    Answer ✓
    Options

    With two Insert data table into Excel Template actions, I merged two tables into an Excel file.

    The first Insert action needs a blank Excel file. The Start row and Start column setting are both 1.

    The second Insert action receives the output from the first one. The start row is 1 and the start column needs a fixed placement. So, if you know your first table always has 5 columns, column 6 is the Start column in the second action.

Categories