Making changes to your Spreadsheet Schema in its editor controls the look and format of data when Clarify reads from or writes to a spreadsheet.
Worksheets, areas, and cells can be edited by selecting them in the Schema section and accessing the Properties view. You can make changes in its Properties tab.
- Add Worksheet
- Add Unbounded Area
- Add Bounded Area
- Add Row Group
- Add Row
- Add Cell
- Expand All
- Collapse All
- Remove: Remove the selected Worksheet, Area, or Field from the Schema
Under the Sample section, the Select Sample File button allows you to browse for a different file to see how it would look with the Schema applied to it.
- Name (of Worksheet)
- Name (of Area)
- Offset from Area
- Offset Row Count
- Name (of Cell)
- Row - Which row of an area the cell belongs in
- Column - The column the cell belongs in
- Default Value On Target - The default value used to populate a field when the source contains null data
Also, when creating a Business Process, if you are writing your target data to a spreadsheet, be sure to use the ConvertSpreadsheet task in the Business Process after the transformation and before writing. See A complete list of Business Process Tasks for more information.