Using a Calculated Column

The Calculated Column element adds a column to a datalayer and is another fine way to synthesize data, i.e. the full name, not found in the database. In this case, the SQL query is straightforward:

SELECT FirstName, LastName FROM Employees

so both columns are returned to the datalayer.

As shown above, a Calculated Column element has been added as a child of the datalayer. Its Formula attribute value is set to concatenate the two name columns, with a space separating them. Its ID attribute becomes the name of the new column added to the datalayer.

The Label element that will display the full name, shown above, references the Calculated Column's ID in an @Data token to retrieve that data.