TransformationNodeBuilder.Build(String) Method

Builds a transformation node with the specified alias.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public TransformationNode Build(
    string alias
)

VB.NET

Public Function Build(
    alias As String
) As TransformationNode

Parameters

Name	Type	Description
alias	String	The alias of a transformation node.

Returns

Type	Description
TransformationNode	A transformation node.

Example

The following example demonstrates how to flatten a data source’s ProductInfo column.

Show JSON Data

[
    {
        "ProductID": 1,
        "ProductInfo":
        {
            "Name": "Chai",
            "UnitPrice": 18
        }
    },
    {
        "ProductID": 2,
        "ProductInfo":
        {
            "Name": "Chang",
            "UnitPrice": 19
        }
    }
]

C#

using DevExpress.DataAccess.DataFederation;
using DevExpress.DataAccess.Json;
// ...
var source = new Source("Products", jsonDataSource);

var query = source
    .Transform()
    .FlattenColumn("ProductInfo")
    .Build("ProductsFlattened");

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

VB.NET

Imports DevExpress.DataAccess.DataFederation
Imports DevExpress.DataAccess.Json
' ...
Dim source = New Source("Products", jsonDataSource)

Dim query = source.
    Transform().
    FlattenColumn("ProductInfo").
    Build("ProductsFlattened")

Dim federation = New FederationDataSource()
federation.Queries.Add(query)

The following schema is the result of the transformation:

"ProductID": int
"ProductInfo_Name": string
"ProductInfo_UnitPrice": string