The Add Missing Columns template is used to add columns to a data file. This is useful when integrating with outside systems that requires your data files to contain a fixed number of columns.
Requirements
The following connectors must be enabled by an org security administrator:
Build your template
The Add Missing Columns template is located in the Workiva Chains section of the Templates screen.
Here's how to find it:
- In Chain Builder, go to the Templates tab.
- Select Workiva Chains from the menu at the top.
- Search for Add Missing Columns at the top right and open the template.
After locating your template, configure it to for your workspace using the variables listed below.
Note: For detailed instructions on creating a chain from a template, see the Create and manage chains article.
Variables
Type | Name | Purpose |
Chain variable | CV_Default Value | Contains the default value that will be populated in the missing columns. To insert a blank value, enter two single quotes (''). |
Dynamic chain variable | DCV_Fields | Used to determine which fields are missing. There is no need to populate this with an initial value. |
Workspace variable | WSR_Field List |
A workspace resource that contains the list of all fields expected in the data file. Requirements:
Example file format: |
Configurable nodes
- Advanced Query - Get Fields in Raw Data: This node assumes the target data file is comma-delimited. If using a different delimiter, then update the input delimiter.
- Render Text Template - Create SQL to Reorder: The parameter can be updated to account for any fields that need to be formatted during the query execution in the subsequent Advanced Query command.
- Render Text Template - Create SQL to Add Missing Fields: If you're not reordering the output, this node can be modified per the Render Text Template - Create SQL to Reorder notes listed above.