The following options are relevant for the "Header" Role type.
Data Manipulation options
Fill in blank cells
- This option is most relevant when you have merged cells and blank cells in the columns. The blank cells will be populated with the value of the cell above them.
- Here are examples of mapping with and without this option:
- Example 1 - all headers were selected (B9-K9) and “fill blanks” option is off. The database table, as seen in the Output Table Preview, some line items values (column B) are blank.
- Example 2 - all headers were selected (B9-K9) and “fill in blanks” option was selected. The database table, as seen in the Output Table Preview, all line items values (column B) are populated.
- Example 3 - in case there are blank cells throughout the table, but you would like to fill the blanks for a single/several column/s only, select the column/s you wish to fill the blanks for as a separate structure (e.g. header, B9) and check the option of filling the blank. Then, add another structure for the rest of the table as headers (C9-K9 in the example above) but keep the “Fill blanks” option off.
Convert to Text
Mixed data types (e.g dates and prices) residing in a single column can cause issues with the way the data is presented in the dashboards or when querying the data. In that case, you can convert all values of those columns to text values during the process of data extraction.
Text values can be manipulated by their letter case. It will affect all the versions in the FileBox, so if you have “Revenues” in one version and “revenues” in another version, you can use the different letter cases to manipulate both outputs to look the same.
Example of the case options, using different letter case as line items:
For more information, check out other Data Mapper articles on the website or contact your Success Manager at DataRails.