--- title: Create a Dataflow Set description: Create a Dataflow Set --- [Skip to content](https://knowledge.bigenius-x.com/create-a-data-flow-set#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en) 3. [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) # Create a Dataflow Set ### Create a Dataflow Set To create a new Dataflow Set, click on the **Plus** icon in the Sets overview on the [**Term Mapping overview**](https://knowledge.bigenius-x.com/understand-term-mapping-overview?hsLang=en) page: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-29-2024-10-00-02-8000-AM.png?width=177&height=152&name=image-png-Feb-29-2024-10-00-02-8000-AM.png) The **Create new Set** side panel window is opened: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Apr-12-2023-02-07-08-1037-PM.png?width=564&height=539&name=image-png-Apr-12-2023-02-07-08-1037-PM.png) Fill in the following information: 1. **Name**: Dataflow Set's name 2. **Description** (*optional*): The Dataflow Set's description 3. **Alias** (*optional*): Dataflow Set's alias 4. **Select Dataflow** (*optional or mandatory*): Dataflow Set's Dataflow 1. If you create the **first Dataflow Set**, the first Dataflow will be automatically created, so you **cannot choose** one. 2. Else, it would be best if you **chose** between the existing Dataflows, for example: ![](https://knowledge.bigenius-x.com/hubfs/image-png-Apr-12-2023-02-11-56-7146-PM.png) 5. **Set Operator** (*optional or mandatory*): Set Operator between the new Dataflow Set and the next one. 1. If you create the **first Dataflow Set** in a Dataflow, you **cannot choose** a Set Operator. 2. Else, it would be best if you **chose** a Set Operator, for example: ![](https://knowledge.bigenius-x.com/hubfs/image-png-Apr-12-2023-02-13-43-2866-PM.png) 6. **Where Clause** (o*ptional*): Where Clause to apply to the complete Dataflow.  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-05-2024-08-46-53-1620-AM.png?width=655&height=48&name=image-png-Feb-05-2024-08-46-53-1620-AM.png) 7. **Having Clause** (*optional*): Having Clause to apply to the complete Dataflow.  ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-05-2024-08-47-17-1705-AM.png?width=688&height=42&name=image-png-Feb-05-2024-08-47-17-1705-AM.png) An IntelliSense editor is available for the Where and Having Clauses. It is based on: -  The source terms of the Dataflow Objects: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-05-2024-08-47-33-3722-AM.png?width=616&height=84&name=image-png-Feb-05-2024-08-47-33-3722-AM.png) - The target technology language - here, SQL: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-05-2024-08-47-59-3117-AM.png?width=603&height=148&name=image-png-Feb-05-2024-08-47-59-3117-AM.png) Click on the **SAVE** button. A notification confirms the correct creation: ![](https://knowledge.bigenius-x.com/hubfs/image-png-Apr-12-2023-02-21-09-1306-PM.png) The new **Dataflow Set** is now visible: ![](https://knowledge.bigenius-x.com/hubfs/image-png-Apr-12-2023-02-22-36-7975-PM.png) You can now start to [**add model objects**](https://knowledge.bigenius-x.com/add-a-model-object-into-a-data-flow-set?hsLang=en) in the **Dataflow Set**. Starting from Generator Configurations release 1.8.0, it is possible to let a Dataflow Set without any Dataflow Set Model Object. This is to be able to create one record with constant values. ### Demonstration video   - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG