Selecting the context with which to run the analysis - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Before you begin

Procedure

  1. Double-click the analysis to open the analysis editor.
  2. In the Data Filter view and in the Where box, either:
    • Enter the name of the context variable you want to use to run the analysis using context. followed by the variable name, or
    • Press Ctrl + space to open the list of context variables created in the Profiling perspective and from which you can select a variable of your choice.

      This list will be empty until you define context variables in the Context view in the analysis editor.

    In this example, type context.where_clause in the Where box.
    Location of the Where box.
    You can use only one context variable to run the analysis. Multiple variables are not supported.
  3. In the Analysis Parameters view and in the Number of connection per analysis field, either:
    • Enter the name of the context variable you want to use to run the analysis using context. followed by the variable name, or
    • Press Ctrl+Space to open the list of context variables.

      This list will be empty until you define context variables in the Context view in the analysis editor.

    For further information about defining context variables, see Creating one or multiple contexts for the same analysis.
  4. In the Context Settings view, select from the list the context environment you want to use to run the analysis, prod for this example.

    The variables of the selected context will show in the table.

    Overview of the Context Settings section.
    All context environments you create in the Context view in the analysis editor or you import from the Talend Studio repository will be accessible from this list.
  5. Run the analysis.
    Table and graphic for the Simple Statistics indicator.
  6. Right-click Row Count in the table and select View rows.

    The SQL Editor opens listing only the data rows where postal code starts with 75.

    Overview of the SQL Editor.