3 Replies Latest reply: Sep 5, 2011 10:02 AM by mdkbayern2011 RSS

    Trying to create a new field from 2 joined tables

    Chris Hopkins

      Hi,

      I have joined 2 tables :

       

      SET cFileName = $(vcGlobalQVD)SubCat.qvd;
      IF QvdCreateTime('$(cFileName)') >= 0 THEN
      SubCat:


      LOAD [Sub Cat],
                Cat,
               [Retail Commodity Group]
             
      FROM $(cFileName) (qvd);
      ENDIF

       

      SET cFileName = $(vcGlobalQVD)Category.qvd;
      IF QvdCreateTime('$(cFileName)') >= 0 THEN
      Category:


      Join LOAD Cat,
                      [Cat Name],
                      Dept
          
      FROM $(cFileName) (qvd);
      ENDIF

       

       

      But now i want to create a new field using     [Retail Commodity Group] from the top table, and  [Cat Name] from the bottom table and name the new field [Retail C.G.]

       

      I have no idea how to create a new field from 2 tables...

       

      Any help would be great.

       

      Thanks

       

      Chris