TransformationNodeBuilder.Build() Method

Builds a transformation node.

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()

VB.NET

Public Function Build As TransformationNode

Returns

Type	Description
TransformationNode	A transformation node.

Example

The following example demonstrates how to unfold and flatten the Products array of two data sources and unite data from these sources.

Show JSON Data (Products1.json)

[
    {
        "CategoryID": 1,
        "Products":
        [
            {
                "ProductName": "Chai",
                "UnitPrice": 18
            },
            {
                "ProductName": "Chang",
                "UnitPrice": 19
            }
        ]
    },
    {
        "CategoryID": 2,
        "Products":
        [
            {
                "ProductName": "Ikura",
                "UnitPrice": 31
            },
            {
                "ProductName": "Konbu",
                "UnitPrice": 6
            }
        ]
    }
]

Show JSON Data (Products2.json)

[
    {
        "CategoryID": 1,
        "Products":
        [
            {
                "ProductName": "Chai",
                "UnitPrice": 18
            },
            {
                "ProductName": "Chang",
                "UnitPrice": 19
            }
        ]
    },
    {
        "CategoryID": 2,
        "Products":
        [
            {
                "ProductName": "Ikura",
                "UnitPrice": 31
            },
            {
                "ProductName": "Konbu",
                "UnitPrice": 6
            }
        ]
    }
]

C#

using DevExpress.DataAccess.DataFederation;
using DevExpress.DataAccess.Json;
// ...
var source1 = new Source("Products1", jsonDataSource1);
var source2 = new Source("Products2", jsonDataSource2);

var query1 = source1
    .Transform()
    .TransformColumn("Products")
    .Build();

var query2 = source2
    .Transform()
    .TransformColumn("Products")
    .Build();

var query = query1
    .Union(query2)
    .Build("ProductsUnited");

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

VB.NET

Imports DevExpress.DataAccess.DataFederation
Imports DevExpress.DataAccess.Json
' ...
Dim source1 = New Source("Products1", jsonDataSource1)
Dim source2 = New Source("Products2", jsonDataSource2)

Dim query1 = source1.
    Transform().
    TransformColumn("Products").
    Build()

Dim query2 = source2.
    Transform().
    TransformColumn("Products").
    Build()

Dim query = query1.
    Union(query2).
    Build("ProductsUnited")

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

The following schema is the result of the transformation:

"CategoryID": int
"Products_ProductName": string
"Products_UnitPrice" : string