Valuestocols Transform

• This indicator value can be a literal value or the output of a function.
• If no indicator value is generated, a null value is written.

This transform is used to generate indicator columns, which can be used in statistical analysis.

• It evaluates entire cell values for uniqueness. It does not scan for individual elements in Object or Array data.
• If a row in the source column contains a missing value, an indicator value is added in a new Empty column.
• It is not appropriate for tabulating counts of strings or patterns in a column. See Countpattern Transform .

Optionally, you can specify a default value, which is applied to all non-indicator value cells in the new column.

Basic Usage

Source:

Transformation:

valuestocols col:Data value:'X'

Results:

Syntax and Parameters

valuestocols col:column_ref value:(expression) default:(expression) [limit:int_num]

For more information on syntax standards, see Language Documentation Syntax Notes.

col

Identifies the column to which to apply the transform. You can specify only one column.

Usage Notes:

value

For the valuestocols transform, this parameter specifies the value to insert in each row of a generated column where the column name of the generated column appears in the same row of the source column. This value can be a string literal, a column reference, or a function.

Usage Notes:

default

Optionally, this parameter can be used to specify the value to insert in each row of a generated column where the column name of the generated column does not appear in the same row of the source column. This value can be a string literal, a column reference, or a function.

If this parameter is not specified, a missing value is inserted.

Usage Notes:

limit

The limit parameter defines the maximum number of columns to create from the unique values detected in the source column. If not specified, the limit is 50.

Usage Notes:

Examples

Example - Basic valuestocols

Source:

This dataset contains onboarding milestones for three employees who joined the company at the same time. The milestones were recorded and organized by date as individual items, so it's not easy to verify that all five milestones have been checked off for each employee:

• Orientation

• Contact Info

• Acquire Computer

• HR Policies Training

• Product Training

Transformation:

The following transform creates columns for each of the values in the onboardingChecklist column and adds a yes value where there is a match for the row:

Results:

In the generated columns, you can quickly assess whether all three employees have completed an individual onboarding item:

• Bud Selig has not acquired his computer.
• Bowie Kuhn has not had product training.

Example - Magazine subscriptions