7 Replies Latest reply: Apr 6, 2018 2:05 AM by Yu Lei RSS

    How to seperate one table to two sames table?

    Yu Lei

      There are no connection and no concatenation between two same tables.

      How to do this ?  Please give me some suggestion.

       

      tab1:

      LOAD [col1],

      [col2],

      [col3],

      [amount]

      FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      tab2:

      LOAD [col1],

      [col2],

      [col3],

      [amount]

      FROM [lib://C/New Microsoft Excel Worksheet.xlsx]

      (ooxml, embedded labels, table is Sheet1);