Convert Collection to Text
Description
This part allows you to convert the contents of a collection to a text string. As an example, this part is used to manage data, for instance in running a data table query as follows:
select governer from state_table where state on ("NY", "DC", "HI")Typically, this part is NOT used for formatting a collection as text to show on the screen, as both report-item (Assessment Framework) and format variable (all frameworks, standalone) offer a wider range of choices for display.
Editor Fields
This part uses the following editor fields:
| Tab |
Field Name |
Description |
Type/Options |
Optional/Mandatory |
| Basic |
Input path |
This is the name of the collection for the system to convert. |
Text |
Mandatory |
| Basic |
Separator |
This is the symbol the system should use to separate the returned values. The default value is a comma (','). |
Text |
Optional |
| Basic |
Add quotes around value |
This setting tells the system to add quotation marks around the returned values. The default setting is 'no'. |
No | Yes |
Mandatory |
| Basic |
Output path |
This is the name of the data object into which the converted text will be stored. |
Text |
Mandatory |
Example
For an example of how to use the Convert Collection to Text part, download and import the following sample project in your workspace.