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