Append Suffix to File/Table Name: Takes the specified database table name and appends a suffix to it.Change Entire File Path: Takes the entire specified database input path and changes it based on the values in the specified field.Change File/Table Name: Takes the specified database table name and changes it based on the values in the specified field.
If you are bringing in Excel files, the sheet name will need to be added to the Full Path using a Formula Tool. Read a List of Data Sources -This section is used for bringing in a list of files, changing table names, or adding Suffix and Prefixes to your Table Names. Note: if your data has different schemas then you want to either fix the schema or create a batch macro that will ignore schema and either load data in by name or position This is a “Template”, so you are able to change this template with the configuration of the tool, but this “Template” is necessary to bring in the data. Input Data Source Template -Connect to your data and choose the tables and fields or files you would like to bring into the workflow. This tool allows you to make adjustments to your SQL queries, Stored Procedures or bring in files with the same schema. So how do we go about doing this? One example is to use the Dynamic Input Tool. Having the ability to be able to adjust what you are bringing into the tool can create tremendous efficiencies. Dynamically adding data into your workflows is one of the really great things about Alteryx.
0 kommentar(er)
