Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411

...

  • It evaluates entire cell values for uniqueness. It does not scan for individual elements in Map 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.

...

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

D s
snippetusage

Required?Data Type
YesString (column name)

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.

D s
snippetusage

Required?Data Type
YesString literal, column reference, or function call

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.

D s
snippetusage

Required?Data Type
NoString literal, column reference, or function call

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.

Info

NOTE: Be careful setting this parameter too high. In some cases, the application can run out of memory generating the results, and your results can fail.

D s
snippetusage

Required?Data Type
No. Default value is 50.Integer (positive)


D s
snippetExamples

Example - Basic valuestocols

...