Text Tables: Statistics For a Non Key Field

Within the LITHOLOGY table, there is a field .Stratum where each row in LITHOLOGY can be assigned a .Stratum integer 1-9. Suppose they are not necessarily in depth order (interlayered) and several LITHOLOGY rows within a POINT might be assigned the same stratum number.

I want to create a text table that contains rows .Stratum 1 through 9 and then in columns evaluations of the project data by stratum (rather than by boring). Column headers such as "Stratum ID", "min. depth stratum was encountered", "list of graphics used in this stratum", etc. However, .Stratum is not a set key by which I can dictate the table. How should I make the data expressions so that the table filters and outputs the way I want?

ie. For key set PointID, Header Text "Stratum ID", I want to output a row for each stratum encountered in the project.

Thanks,

Parents
  • Just to clarify before I head down the wrong path. You want to output a table that has 9 and only 9 rows labeled stratum 1, stratum 2, etc. Columns would be min depth, max depth, min thickness, max thickness, etc. These outputs would be based on all borings selected at output time. 

    Is there any reason you need to use a text table?

    Not saying I know how to do it, just dont want to waste my time doing something you dont want. It would be helpful if you posted an example table that shows what you are expecting (create it in word and export as a jpg to post here, doesn't have to include real data, just the type of output you expect)

  • The stratum field entry is limited to integers 1-9, so those row only will be fine, or only rows for strata are actually used  is fine, also.

    I have the rest of my data displays (except logs and fences) in text-table format because they are easy to export to Excel for use in my company's reports, so it made the most sense for me to use a text-table for this.

    Your written interpretation of what I would like to display is correct, "rows labeled stratum 1, stratum 2, etc. Columns would be min depth, max depth, min thickness, max thickness, etc. These outputs would be based on all borings selected at output time."

    For the first column I have been trying a bunch of SQL statements so far, but no luck. Hopefully I am at least on the right track.

    <<SQL(Select [LITHOLOGY].[Stratum] From [LITHOLOGY])>>

    <<SQL(Select Distinct [LITHOLOGY].[Stratum] From [LITHOLOGY])>>

    <<Iterate(ID,1,9,,,<<SQL(Select [LITHOLOGY].[Stratum] From [LITHOLOGY] Where [LITHOLOGY].[Stratum] = <<Get(ID)>>)>>)>>

Reply
  • The stratum field entry is limited to integers 1-9, so those row only will be fine, or only rows for strata are actually used  is fine, also.

    I have the rest of my data displays (except logs and fences) in text-table format because they are easy to export to Excel for use in my company's reports, so it made the most sense for me to use a text-table for this.

    Your written interpretation of what I would like to display is correct, "rows labeled stratum 1, stratum 2, etc. Columns would be min depth, max depth, min thickness, max thickness, etc. These outputs would be based on all borings selected at output time."

    For the first column I have been trying a bunch of SQL statements so far, but no luck. Hopefully I am at least on the right track.

    <<SQL(Select [LITHOLOGY].[Stratum] From [LITHOLOGY])>>

    <<SQL(Select Distinct [LITHOLOGY].[Stratum] From [LITHOLOGY])>>

    <<Iterate(ID,1,9,,,<<SQL(Select [LITHOLOGY].[Stratum] From [LITHOLOGY] Where [LITHOLOGY].[Stratum] = <<Get(ID)>>)>>)>>

Children
No Data