-
Interactive DashboardsCreate interactive BI dashboards with dynamic visuals.
-
End-User BI ReportsCreate and deploy enterprise BI reports for use in any vertical.
-
Wyn AlertsSet up always-on threshold notifications and alerts.
-
Localization SupportChange titles, labels, text explanations, and more.
-
Wyn ArchitectureA lightweight server offers flexible deployment.
-
Wyn Enterprise 7.1 is ReleasedThis release emphasizes Wyn document embedding and enhanced analytical express... -
Choosing an Embedded BI Solution for SaaS ProvidersAdding BI features to your applications will improve your products, better serve your customers, and more. But where to start? In this guide, we discuss the many options.
-
Visual GalleryInteractive sample dashboards and reports.
-
BlogExplore Wyn, BI trends, and more.
-
WebinarsDiscover live and on-demand webinars.
-
Customer SuccessVisualize operational efficiency and streamline manufacturing processes.
-
Knowledge BaseGet quick answers with articles and guides.
-
VideosVideo tutorials, trends and best practices.
-
WhitepapersDetailed reports on the latest trends in BI.
-
Choosing an Embedded BI Solution for SaaS ProvidersAdding BI features to your applications will impr... -
- Getting Started
- Administration Guide
-
User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Data Governance and Modeling
- View and Manage Documents
- Working with Resources
- Working with Reports
- Working with Dashboards
- Working with Notebooks
- Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
Add Columns
The Add Columns transformation command is used to add one or more columns with a formula that uses the values of the input columns. The formula gets evaluated to create a new column in the output of the command. You can also use the command to add a column with constant values for example to identify the source of the data.
Configuration
After you add an Add Column ETL command to the ETL designer and connect an input to it, you need to provide:
A name for the new column.
A formula.
Click the Expand icon (two arrow-headed icon) to open the Expression editor and enter the formula. The expression editor shows all the functions you can use in the formula and you can drag and drop columns to build the formula.
Click Add Calculated Column to add a column with a formula or Add Constant value to the output of the command. You can remove a field by clicking the Recycle Bin icon to the right of each field.
This data flow uses two instance of the Add Calculated Column command. The first one adds an ExtendedPrice column which multiples the unit price with quantity columns. The second instance uses the ExtendedPrice column to add two more columns for the discount and PaymentDue columns.