TransformationNodeBuilder.Build(String) Method

Builds a transformation node with the specified alias.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v25.2.dll

NuGet Package: DevExpress.DataAccess

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Build(String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting-How-to-Bind-a-Report-to-a-Transformation-Based-Query/CS/Form1.cs#L35

Source jsonSource = new Source("json", jsonDataSource);
TransformationNode query = jsonSource
    .Transform()

VB.NET

Reporting-How-to-Bind-a-Report-to-a-Transformation-Based-Query/VB/Form1.vb#L37

Dim jsonSource As New Source("json", jsonDataSource)
Dim query As TransformationNode = jsonSource.Transform().TransformColumn("Products").Build("Transformation")
federationDataSource.Queries.Add(query)