Skip to main content
All docs
V24.1

TransformationNodeBuilder.TransformColumn(String) Method

Transforms a column.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

public TransformationNodeBuilder TransformColumn(
    string columnName
)

Parameters

Name Type Description
columnName String

The name of a column that should be transformed.

Returns

Type Description
TransformationNodeBuilder

The result of the transformation query.

Remarks

If a column is an array, the TransformColumn method unfolds this column and then flattens it. The Unfold operation transforms each element of the array into an individual record. The Flatten operation creates individual columns from the fields of these records.

Example

The following example demonstrates how to unfold and flatten a data source’s Products array:

Show JSON Data
[
    {
        "CategoryID": 1,
        "Products":
        [
            {
                "ProductName": "Chai",
                "UnitPrice": 18
            },
            {
                "ProductName": "Chang",
                "UnitPrice": 19
            }
        ]
    },
    {
        "CategoryID": 2,
        "Products":
        [
            {
                "ProductName": "Ikura",
                "UnitPrice": 31
            },
            {
                "ProductName": "Konbu",
                "UnitPrice": 6
            }
        ]
    }
]
using DevExpress.DataAccess.DataFederation;
using DevExpress.DataAccess.Json;
// ...
var source = new Source("Products", jsonDataSource);

var query = source
    .Transform()
    .TransformColumn("Products")
    .Build("ProductsUnfoldedAndFlattened");

var federation = new FederationDataSource() {
    Queries = { query }
};

The following schema is the result of the transformation:

"CategoryID": int
"Products_ProductName": string
"Products_UnitPrice": int
See Also