input_data1 = Open( "test_file_1.xlsx", Worksheets( "Sheet1" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Invisible, Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 0 ), Data Ends on Column( 0 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 0 ), Suppress Hidden Columns( 0 ), Suppress Empty Columns( 0 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ) ); input_data2 = Open( "test_file_2.xlsx", Worksheets( "Sheet1" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Invisible, Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 0 ), Data Ends on Column( 0 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 0 ), Suppress Hidden Columns( 0 ), Suppress Empty Columns( 0 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ) ); // input_data3 = Open( // "test_file_3.xlsx", // Worksheets( "Sheet1" ), // Use for all sheets( 1 ), // Concatenate Worksheets( 0 ), // Invisible, // Create Concatenation Column( 0 ), // Worksheet Settings( // 1, // Has Column Headers( 1 ), // Number of Rows in Headers( 1 ), // Headers Start on Row( 2 ), // Data Starts on Row( 3 ), // Data Starts on Column( 1 ), // Data Ends on Row( 0 ), // Data Ends on Column( 0 ), // Replicated Spanned Rows( 1 ), // Replicated Spanned Headers( 0 ), // Suppress Hidden Rows( 0 ), // Suppress Hidden Columns( 0 ), // Suppress Empty Columns( 0 ), // Treat as Hierarchy( 0 ), // Multiple Series Stack( 0 ), // Import Cell Colors( 0 ), // Limit Column Detect( 0 ), // Column Separator String( "-" ) // ) // ); output_table1 = input_data1; output_table1 << Concatenate(input_data2, Append to first table); // output_table1 << Concatenate(input_data3, Append to first table); output_table1 << New Data View; output_table2 = input_data2; output_table2 << Concatenate(input_data1, Append to first table); // output_table2 << Concatenate(input_data3, Append to first table); output_table2 << New Data View;