Displaying 2 results from an estimated 2 matches for "parvq".
Did you mean:
parv
2011 Jan 13
0
Help with Data Transformation - RESOLVED
...or each sample ID I would like to create a single line;
- Extract each "PARLABEL" to use as a column name; and
- Place the "Result" in the appropriate column.
* I can subset the data so that "prccode", "Lab", "EXMCODE", "Analysis", "PARVQ", "RL",
"EPA_FLAGS", and "units" are irrelevant to the issue.
The following snippet should illustrate the absolute minumum needs:
INPUT
fldsampid | PARLABEL | Result
------------+--------------+---------
fldsampid1 | PARLABEL-a | value-8
fldsampid1 |...
2011 Jan 10
3
Help with Data Transformation
...derful community,
Guy Jett, R.G.
Project Geologist
gjett@itsi.com<mailto:gjett@itsi.com>
Example Data Input (subset):
fldsampid CLP_ID sacode matrix etc... prccode Lab EXMCODE Analysis PARLABEL PARVQ Result
2268 LHR020GW-01E2 N WG INO BRLS NONE E300 CL = 23590.9
2269 LHR020GW-01E2 N WG INO BRLS NONE...