Supply Default for Column
- 26 Oct 2022
- 1 Minute to read
- Print
- DarkLight
Supply Default for Column
- Updated on 26 Oct 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
The Supply Default For Column step cannot be searched for and is located under Integrations > Excel and CSV. This step allows the user to set desirable default values for columns in their excel spreadsheet that have empty fields. When mapping the step, the user must supply a document, specify the file type (CSV, Excel_xls, or Excel_xlsx), determine which column will be altered, and input the default value for the specified column will be.
Properties
The Properties section describes every property/setting available for that specific step. The tables within the settings should have the property name, a brief description, and the data type that the property is expecting/outputting. Include a screenshot of the step in use in a Flow. Also include related forum posts and example labs.
Inputs
| Property | Description | Data Type |
|---|---|---|
| File | The CSV or Excel file used as the input. | FileData |
| FileType | Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect. | CSVFileType |
| Worksheet Number | Determines which worksheet that will be edited. | Int32 |
| Column | The starting column, where the values will be inserted, starts at 0. | Int32 |
| Default Value | The value to be added to the excel or CSV file. | String |
Outputs
| Property | Description | Data Type |
|---|---|---|
| None | --- | --- |
Was this article helpful?
