8 Replies Latest reply: Jul 3, 2014 4:50 AM by mugdha tasgaonkar RSS

    Resident table loading problem-No table found

      I have two tables with same columns, (current years data and previous years data)

       

      curr_year:

      load a,b,c

      from

      curr_year_qvd.qvd(qvd);

       

      Noconcatenate

      //prev_year:

      load a,b,c

      from

      prev_year_qvd.qvd(qvd);

       

      yearly_data:

      load a,b,c

      resident curr_year;

       

      inner join (yearly_data)

      load c,d,e

      from currency_dat.qvd(qvd);

       

      ideally yearly_data table should give me consolidated result, but it gives me error while loading "table not found".

       

      i want to take cosolidated result in one table and then join currency table with this cosilidated table.

       

      How can i resolve this?