4 Replies Latest reply: Jul 28, 2016 12:48 AM by Karunpreet Soni RSS

    Concatenate Tables starting with common prefix

    Karunpreet Soni

      Hi Everyone,

       

      I have few tables in my data model which start with 'T_' .

       

      I want to concatenate all the tables in my data model which have there names starting from 'T_'.

       

      I tried the following code ,

       

      F:

      Load *

      Resident [T_*];

       

      But it's not working.

       

       

      Please suggest if this can done or not. And if yes, then how.

       

      Also don't suggest me to make a qvd of all and store them into a common folder and then extract them. As I have around 500 tables like that

       

      Thanking you all in anticipation

       

      Regards

      Karunpreet