Tables: Join all tables in a column

Options
GT_801564
GT_801564 Posts: 7
edited March 2020 in Ideas

Problem

I have a table with a column of datatable ID references. I need to join all the table into a single table

Idea

An action similar to Tables: Sum Data in a Column where the input is a column reference of datatable IDs or a datatable type column and the output is a single datatable of all the joined tables

2
2 votes

Swept · Last Updated

Comments

  • Jeff_146001
    Jeff_146001 Posts: 296 admin
    Options

    @Kevin_142792 In this example, do all those tables have identical columns? And if so, you'd be looking to essentially append the data of each table after the others, right?

  • Kevin_102667
    Kevin_102667 Posts: 56 admin
    Options

    @Jeff_766580 Yes to both. All those tables have identical columns and I want to append data of each table after the other. I find the need to do this often on the Successful Runs Data Table after executing a Tables: Start Pushbot for Each Row task.

  • Jeff_146001
    Jeff_146001 Posts: 296 admin
    Options

    I'm sure you know this @Kevin_102667, but for others, the workaround would be to use the action, Tables: Start a Pushbot for Each Row, and then add the action Tables: Copy a table to another table in the subprocess.

Categories