Hi Nick,

Multiple columns in standards can occur when you have conditionally based standards, such as depth dependancies, matrix dependancies, chem code depaendancies.

I suspect this is the case with the tables where you have two columns (Boron>1.5m, HWS Boron<1.5m).

Cheers,

Nick

Hi Nick,

ESdat Desktop does this also:

range.JPG (187kb) downloaded 2 time(s).

I note in your example that the line with the EQL has been merged with the Standard name, which is where this depth range should be.

Can you please post a screenshot of the Table Layout tab of the Chemistry Table Output Setup (from the More Options button before you click Finish on the export)?

Does the depth information export if you modify any of these settings?.

Thanks,

Nick

Hi Nick,

I'm not sure that screenshot attached correctly.

Nevertheless, I have been able to replicate this using a very similar setup to how your data was presented.

It seems to be related to the fact that there is only one conditional depth included in the standard.

If all parameters in the standard have a conditional depth applied, then it outputs with the depth info shown.

We will look into why it is doing this.

As a workaround, setting the Conditional_Depth_From value for the other paramters to 0 will allow the headers to export.

Thanks,

Nick

Hi Nick,

No that is likely to duplicate the records (duplicates are allowed on this table to allow the conditions).  If you want to use this approach, you'll need to delete the standard completely.

You'd be better off just editing directly within zRef_Environmental_Standards.

Apply the following filter (please double check the filter is correct for your data so you don't accidentally populate other standards as well):

ActionLevelSource =   'Table 2 - Agricultural or Other, coarse soil'  AND Conditional_Depth_From Is Null

Then you should be able to select the Conditional Depth From column using the header, and the value you type in the first cell will be filled down.

Cheers,

Nick

Edited by user Wednesday, November 20, 2019 10:27:11 AM(UTC)  | Reason: Not specified

ChemistryTable (9).xlsx (42kb) downloaded 4 time(s).So the quick fix worked fine for Desktop, but had an unintended consequense for Server. See attached Chemistry Table (9).xlsx. Now there are four standards colums, one of which is blank.