Creating a Duplicate Table with selected Columns

This feature is useful when you are creating a specimen table or a duplicate table.  It is much faster than querying the data twice from OpenGround and it requires less API usage (i.e costs less!)

To create a duplicate table with selected columns follow the steps below

• Open the data View for your report by clicking on the data grid icon down the left-hand side of your report.
• Select New Table from the Table Tools Ribbon.  This creates a blank table and presents the option to define the table using an equation.
•  Enter the following equation into the formula bar.  This will create a table called "SubTableofGrading" and include the GradingType and GradingDepthTop from the Grading table and renames them to sampletype and TopDepth. 
  • SubTableofGrading = SELECTCOLUMNS(grading,"Sampletype",[GradingType],"TopDepth",[GradingDepthTop])

Additional fields can be added to this equation by adding additional parameters to the end of the parameters.  The first parameter in the pair is the new fieldname and the second is the fieldname from the original table.