Is there an easy way to produce a line on a plot from a comma delimited list of coordinates?
Specificaly:
Independent variable = <<expressionX1>>,<<expressionX2>>,<<expressionX3>>,<<expressionX4>> ...
Dependendant variable = <<expressionY1>>,<<expressionY2>>,<<expressionY3>>,<<expressionY4>> ....
to produce a line with coordinates (X1,Y1) , (X2,Y2) , (X3,Y3) , (X4,Y4) ...
Plot would have keyset PointID, Depth to produce a plot for each sample.
Not sure if this is possible but before I get into more complex things like scripts or data structure conversion I want to make sure there is not a simple way I am overlooking.
Thanks
Hi
This question has come up a few times on this forum, see
communities.bentley.com/.../218110.aspx
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Phil
Thanks for pointing me to that post but I fear it is not quite what I was looking for... The IndDepList command appears to be for specifying "curves from equations" to show on graphs. What I am looking for is something similar that will plot the primary data on the graph. To clarify what I am looking for:
I have a data table that has fields
PointID, Depth, Reading1, Reading2, Reading3, Reading4, Reading5
Each of the readings (1-5) is associated with a predefined independent variable but this is not explicitly stored in the data structure.
It would be easy if the data table was aranged as:
PointID, Depth, IndependentVarible, Reading
So that each reading is automatically associated with it's correct independent variable. I could then specify <<FieldName.IndependentVariable>> as the independendant axis and <<FieldName.Reading>> as the depenent axis and plot results from multiple points and depths on a single summary plot.
Unfortunately it is not arranged that way and there are compeling reasons for the way it is arranged. Thus I seem to have three options:
1. Use the IndDepList comand to create the plot entirely using the "curves from equations" feature and leave the actual data fields blank. Not quite sure this would work since if no data is ploted the form will probaly fail to plot, Haven't tried it though so may look into that.
2. Find another method for ploting the primary data from a delimited list of verticies, indepentant variables or dependant variables. This is what I am hoping for and any help would be appreciated.
3. Write a script or gINT Rule to convert the data structure and create a new table that has fields:
Then reference the graph form to those new fields. Not really looking forward to that since it would involve creating several records from one record which I don't have a clean way to do. Also, it makes the data structure cumbersome since I would want to maintain the original table and the new table. I would probaly hide the new table so that new entries and corrections get entered in the original table and then automatically updated to the new hidden table.