# Creating Field Profiles

*Field Profile* captures statistics for selected fields from one or several objects. Field Profile is essentially a transformation object as it provides *Input* and *Output* ports similar to other transformations. The *Output* ports make it possible to feed the statistics collected to another object on the dataflow, for example, a destination database table, which can then be used to analyze the collected data.

{% embed url="<https://youtu.be/BQPSsux2_n4?feature=shared>" %}

An example of a dataflow fragment with a *Field Profile* in it is shown below:

![](/files/Xw3F1ZtuPaC5odjLaoqv)

Statistics will be collected only for the fields linked to the Input port of the Field Profile object. This way, you can selectively collect statistics for a subset of fields from the selected field layout.

{% hint style="info" %}
**Note**: To preview field statistics, right-click on a Field Profile object and select *Preview Data.*
{% endhint %}

To add a field profile, drag the *Field Profile* object from the *Logs and Profiles* group in the Flow toolbox and drop it on the dataflow.

To configure the properties of a Field Profile object, right-click on it and select *Properties*. The following properties are available:

* *Meta Object Builder screen* is used to add or remove fields in the field layout, as well as select their data type.

{% hint style="info" %}
**Note**: To quickly add fields to the layout, drag and drop the node *Output* port of the object whose layout you wish to replicate into the node Input port of the *Field Profile* object. The fields added this way show in the list of fields inside the *Input* node and as well as in the *Meta Object Builder*.
{% endhint %}

* *Field Profile Properties screen:*
  * *Case Sensitive:* Turn this option on if you need to collect statistics using case sensitive comparison for strings.

## **Usage**

In the example below, field profile object collects statistics for field ‘test’ and saves it to an Excel spreadsheet.

![](/files/WQjjfPFFSle9E474rcb3)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v6/dataflows/data-logging-and-profiling/creating-field-profiles.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.