I’m trying to run a calculation to fill out an empty column in a GAS file, but it wouldn’t let me do that because there is an existing column with the same aliased element.

A: This can be explained using an example. I have 4 columns: P_ppm, Ti_ppm, P2O5_pct and TiO2_pct. The first two columns (P_ppm and Ti_ppm) have data in all rows. Most of the rows in the last two columns (P2O5 and TiO2) are empty, with some cells containing values. I want to populate the remaining cells in the last two columns using Make Input Columns in Create New Geochem Calculation, and by selecting P2O5 and TiO2 as the input columns. However, no values were created to fill the empty cells in P2O5 and TiO2.

The overriding principle with element conversion in ioGAS is that it won’t run calculation to create something that already exists. In this case, the conversion will not create any values for columns P2O5 and TiO2, because ioGAS assumes that the existing values are correct. If the original columns for P2O5 and TiO2 are renamed (e.g. to P2O5_pct_ and TiO2_pct_), then the columns for P2O5 and TiO2 will be populated with values. However, if the original columns for P2O5 and TiO2 are removed, ioGAS will recalculate the columns.

代 写