0

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.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 yr agoLast active
  • 18Views
  • 3 Following

Home