This deprecated node reads a small set of data stored within the data flow. This node is typically used when a small amount of unchanging data needs to exist within a data flow, often for test cases or examples.
The content should be standard CSV-formatted (Excel style) data, with a proper header line (name:type), and data properly separated and escaped.
For information on data types, see Data types.
Example
In the StaticData property, you enter the following data.
ID:long,Field:unicode,Value:unicode1,CustomerName,Martine Rance1,TotalProductsPurchased,502,CustomerName,Miguel Angel Paolino2,TotalProductsPurchased,14
The output formats the above data in a table, as follows:
| IDlong | Fieldunicode | Valueunicode |
|---|---|---|
| 1 | CustomerName | Martine Rance |
| 1 | TotalProductsPurchased | 50 |
| 2 | CustomerName | Miguel Angel Paolino |
| 2 | TotalProductsPurchased | 14 |
Properties
StaticData
Specify comma separated data to be output into the data flow. The content should be standard CSV-formatted (Excel style) data, with a proper header line (name:type), and data properly separated and escaped. For raw strings (containing backslashes that should not be interpreted, such as windows paths) use the data type 'rawString'.
Inputs and outputs
Inputs: None.
Outputs: out1.