2 Replies Latest reply: Sep 10, 2015 8:22 AM by Hasvine Dhurmea RSS

    Dynamic merge of table

    Hasvine Dhurmea

      Hello All,

       

      I have a campaign whereby for each month a new table is created on my SQL database.

      Example:

       

      MonthTable name in SQL database
      August201508_XXXXXXXX
      September201509_XXXXXXXX
      October201510_XXXXXXXX
      November201511_XXXXXXXX
      December201508_XXXXXXXX

       

      Now my problem is that I have created a QVW which pull data from the table 201508_XXXXXXXX and now the only way is to change the table in the load script every month.

       

      Is there a way that I can do it dynamically.

       

      Note that I have another table in my SQL database which link the table to the campaign id.

       

      Campaign IDTable name in SQL database
      D1230258789201508_XXXXXXXX
      D1230258789201509_XXXXXXXX
      D1230258789201510_XXXXXXXX
      D1230258789201511_XXXXXXXX
      D1230258789201512_XXXXXXXX

       

       

      Any idea how i can proceed.

       

      Kind Regards,

       

      Hasvine