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 ,



      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