0 Replies Latest reply: Apr 30, 2012 6:36 PM by markpinches RSS

    Pivot like load?- help please!

      Hi all,

       

      I have an issue that I think probably has a fairly simple answer ! - its just eluding me at the moment...

       

      I load in the following tables:

       

      GROUPFORMULA:

      Load FORMULATIONID,

      FORMULATIONTYPE,

      GROUPID

      FROM $(v_QvdPath)GROUPFORMULA.qvd (qvd);

       

      FORMULATION:

      Load COMPOUNDID,

          DOSELEVEL,

          DOSELEVELSTR,

          FORMULATIONID,

          FORMULATIONTYPE

      FROM $(v_QvdPath)FORMULATION.qvd (qvd);

       

      COMPOUND:

      Load COMPFULLNAME,

      COMPOUNDID,

          COMPOUNDNAME,

          BRANDNAME

      FROM $(v_QvdPath)COMPOUND.qvd (qvd);

       

      Now FORMULATIONTYPE contains three types of data "M", "R" and "V"

       

      Id like the eventual data to load in to the model so that each GROUPID has three columns M_COMPFULLNAME, R_COMPFULLNAME and V_COMPFULLNAME (plus the others too)

       

      Any ideas on how to code it? what functions should I look at using?

       

      Thanks

       

      Mark