Composite Text Column

This application, as shown in the Figure below, allows users to merge several columns of data into a single text field within Geoscience ANALYST.

This transformation is particularly useful when preparing data for use with Large Language Models (LLMs), which require a unified text input. Instead of analyzing several separate properties, users can generate a single composite text field that summarizes all relevant information in one place.

../_images/composite_principle.png

The application takes selected columns, formats them into a readable string, and outputs a new text property associated with the data object. This combined text can then be used as input for downstream LLM tasks, such as summarization, classification, or question answering.

The resulting text field is saved directly in Geoscience ANALYST, enabling users to quickly visualize or export it for further analysis.

Interface

You can run the application using the interface shown in the Figure below.

../_images/composite_uijson.png

The interface contains the following parameters:

  • Drillhole Data: The drillhole group and associated properties to concatenate.

  • Object: The object containing the text properties.

  • Data: The text properties to concatenate. Multiple fields can be selected; they will be combined into one composite text output.

  • Output Name (optional): The name of the output text field. If not provided, the output will be named after the selected properties with a “_concatenated” suffix.

  • OK: Clicking “OK” runs the application and generates a new text field with the concatenated content.

Optional Parameters

../_images/composite_uijson_optional.png

  • Headers (optional): A comma-separated list of custom labels to replace the original property names in the concatenated output. The number of headers must match the number of selected properties. If the number does not match, the application will return an error.

Once executed, the resulting text field will be added to the selected object within Geoscience ANALYST, ready for use in downstream LLM applications or exports.

Results

As presented in the figure below, the selected text properties are merged into a new text field. The output consists of each entry formatted as: Header1: value1; Header2: value2, ... for every row. This new field is associated to the selected object.

../_images/result_composite.png