5 Replies Latest reply: Jul 2, 2014 2:58 PM by Massimo Grossi RSS

    concatenated tables and then join

    Vinay kumar Bangari

      Hi ,

       

      I have a wierd scenario that is

       

      Table1:

      load A, B, C

      from table1;

       

      concatenate(Table1)

      load A, B, C

      from table2;

       

      concatenate(Table1)

      load A, B, C

      from table3;

       

      join(table1)

      Load A, B, D, E from facttable_*;

       

       

      after join statement facttable_* , Here * indicates years 2011, 2012, 2013. it will have 3 tables which needs to be concatenated and then join. Problem from me is , the second (2012 ) QVD and third 2013 QVD is not joining properly. Because of that i am not getting the data from the second and 3rd QVD. Need your inputs on how to solve this issue.