6 Replies Latest reply on Nov 6, 2018 12:26 AM by Deepak Rai

    How to select all tables from one database and append them?

    Yun Feng

      Hi

       

      I have one sqlite3 database, there are many tables. How can I select them all and append them, change the column name? Like:

      First table:

      标题 1标题 2标题 3
      DATEAA_ELSE
      2018010112
      2018010234

      Second Table:

      标题 1标题 2标题 3
      DATEBB_ELSE
      2018010147
      2018010261

       

      How can I get all data and append them as data source?

      标题 1标题 2标题 3
      DATEPRODUCEVALUE
      20180101A1
      20180101A_ELSE2
      20180102A3
      20180102A_ELSE4
      20180101B4
      20180102B_ELSE7
      20180101B6
      20180102B_ELSE1

       

      Thanks!