12/27/2023 0 Comments Tableau prep 2021.4Required parameter values must be entered before the user can run the flow. When running the flow, users are prompted to enter the parameter values. You can make flow parameter values required or optional. You can also define parameters that accept all values, which means any flow user can enter any value when running the flow. Create parameters from the top menu, then define the values that apply to them. ![]() User parameters are specific to the flow where they are used. Expression editor: Filters and calculated field values.Output to database: Apply user parameters to the table name and starting in version 2022.1.1, to SQL scripts that you run before or after writing the flow output to a database.Output to server: Apply user or system parameters to the published data source name.Apply system parameters to the file name. Output to file: Apply user parameters to the file name or file path and starting in version 2022.1.1, to the Microsoft Excel worksheet name.Connect to database: Use parameters for the table name and in Custom SQL.Connect to file: Use parameters in the file name or file path.The following table lists the locations where you can apply parameters for each step type. You can apply system parameters (version 2023.2 and later) to output names for file and published data source output types. For more information, see Flow Methods (Link opens in a new window) in the Tableau Rest API help. Starting in version 2022.1.1, you can even include parameter override values when running flows using the REST API. You can apply user Parameters to file names, paths, table names, filter expressions, and calculated fields, depending on the step type. Starting in Tableau Prep Builder and Tableau Cloud version 2023.2, you can also add system parameters to the file or published data source output name to automatically add a time stamp each time you run the flow. ![]() For example, you can create a parameter for various sales regions, then apply a parameter value to the input file path to run the flow using just that region's data. Instead of building and maintaining multiple flows, you can now build one flow and use parameters to run the flow with your different data sets. A parameter is a global placeholder value such as a number, text value, or boolean value that can replace a constant value in a flow. ![]() If you often reuse flows using different data with the same schema, you can create and apply user parameters to your flows to easily transition between scenarios. For more information about authoring flows on the web, see Tableau Prep on the Web in the Tableau Server (Link opens in a new window) and Tableau Cloud (Link opens in a new window) help. Note: The content in this topic applies to authoring flows in Tableau Prep Builder and on the web, unless specifically noted. Supported in Tableau Prep Builder version 2021.4.1 and later and on the web in Tableau Cloud and Tableau Server version 2021.4.0 and later
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |