Collects distinct values from a column and populates a value table with these.
Example

I Ain't Afraid of No Code!
[
[
"collect",
{
"subtable": null,
"flush": true,
"column": "Campaign",
"table": "Campaign Names",
"_comment": null
}
]
]
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param list column: Column to be used for Value table.
param str table: Value table to be generated from column.
param boolean flush: Flush value table before populating it.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.