UploadData
The UploadData() function uploads data to Quintessence using a configured data feed and a range of data as input. Typcially a data feed would take a file as input and apply transformations to any columns where necessary. Upload data passes a range of cells or an array to the data feed and bypasses any transformations.
Syntax
UploadData (Data Feed, Range, ShowError)
| Data Feed | The name of the data feed on the Quintessence server |
| Range | The range of Excel cells to upload. Note, this could also be an array passed as a parameter. |
| ShowError | For this function, the Show Error parameter accepts a set of options, and the output differs accordingly. The options are as follows: “NoLog”, “Errors”, “Warnings”, “NoLogWarnings”, and “NoLogErrors”. See the table below for the expected output for each option. |
| There are warnings but no errors | There are errors (and possibly warnings) | There are no errors or warnings | |
| NoLog | TRUE | The feed executed with errors/warnings | TRUE |
| Errors | TRUE | The list of errors | TRUE |
| Warnings | The list of warnings | The list of errors | TRUE |
| NoLogWarnings | The feed executed with warnings | The feed executed with errors/warnings | TRUE |
| NoLogErrors | TRUE | #VALUE | TRUE |