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:
FROM $(v_QvdPath)GROUPFORMULA.qvd (qvd);
FROM $(v_QvdPath)FORMULATION.qvd (qvd);
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?