FAQ: Which parameters can I use to modify a transform?

FAQ: Which parameters can I use to modify a transform?

All transforms written in Wrangle conform to the following format:
<transform> <parameter>: <function and/or argument>
Each transform can be modified by one or more parameters. Each combination of transform and parameter can execute a specific set of functions on arguments. The following table shows the relationships between transforms, parameters, and functions in Trifacta:
TransformParameter(s)Function(s)
aggregatevalue, groupcount, kthlargest, list, max, min, mean, sum, stdev, value
countpatternafter, at, before, col, field, from, ignoreCase, on, quote, toN/A
deduplicateN/AN/A
deleterowabs, ceil, char, coalesce, concat, count, cross, date, datediff, dateformat, datetime, day, dayofweek, domain, empty, exp, find, floor, hour, in, intersection, invalid, ipfromint, iptoint, isempty, isvalid, keyset, kthlargest, left, length, list, ln, log, lowercase, matches, max, mean, min, minute, mismatched, month, monthname, next, null, numformat, pow, prev, propercase, rand, right, round, second, session, sqrt, stdev, subdomain, substring, suffix, sum, time, trim, unicode, unique, unixtime, unixtimeformat, uppercase, valid, var, windowfunc, year, zip
derivevalue, groupabs, ceil, char, coalesce, concat, count, cross, date, datediff, dateformat, datetime, day, dayofweek, domain, empty, exp, find, floor, hour, in, intersection, invalid, ipfromint, iptoint, isempty, isvalid, keyset, kthlargest, left, length, list, ln, log, lowercase, matches, max, mean, min, minute, mismatched, month, monthname, next, null, numformat, pow, prev, propercase, rand, right, round, second, session, sqrt, stdev, subdomain, substring, suffix, sum, time, trim, unicode, unique, unixtime, unixtimeformat, uppercase, valid, var, windowfunc, year, zip
dropcolN/A
extractafter, at, before, col, from, ignoreCase, limit, on, quote, to, urlparamN/A
extractkvcol, delimiter, key, quote, valueafterN/A
extractlistcol, delimiter, on, quoteN/A
headerN/AN/A
keeprowabs, ceil, char, coalesce, concat, count, cross, date, datediff, dateformat, datetime, day, dayofweek, domain, empty, exp, find, floor, hour, in, intersection, invalid, ipfromint, iptoint, isempty, isvalid, keyset, kthlargest, left, length, list, ln, log, lowercase, matches, max, mean, min, minute, mismatched, month, monthname, next, null, numformat, pow, prev, propercase, rand, right, round, second, session, sqrt, stdev, subdomain, substring, suffix, sum, time, trim, unicode, unique, unixtime, unixtimeformat, uppercase, valid, var, windowfunc, year, zip
moveafter, before, colN/A
nestcolN/A
renamecol, toN/A
replaceat, col, global, on, withN/A
mergecol, withN/A
setcol, row, valueabs, ceil, char, coalesce, concat, count, cross, date, datediff, dateformat, datetime, day, dayofweek, domain, empty, exp, find, floor, hour, in, intersection, invalid, ipfromint, iptoint, isempty, isvalid, keyset, kthlargest, left, length, list, ln, log, lowercase, matches, max, mean, min, minute, mismatched, month, monthname, next, null, numformat, pow, prev, propercase, rand, right, round, second, session, sqrt, stdev, subdomain, substring, suffix, sum, time, trim, unicode, unique, unixtime, unixtimeformat, uppercase, valid, var, windowfunc, year, zip
settypecol, typeN/A
sortorderN/A
splitafter, at, before, col, from, ignoreCase, limit, on, quote, toN/A
splitrowsN/AN/A
unnestcol, keys, pluckN/A
unpivotcolN/A
valuestocolscol, valueN/A
windowgroup, order, valueabs, ceil, char, coalesce, concat, count, cross, date, datediff, dateformat, datetime, day, dayofweek, domain, empty, exp, find, floor, hour, in, intersection, invalid, ipfromint, iptoint, isempty, isvalid, keyset, kthlargest, left, length, list, ln, log, lowercase, matches, max, mean, min, minute, mismatched, month, monthname, next, null, numformat, pow, prev, propercase, rand, right, round, second, session, sqrt, stdev, subdomain, substring, suffix, sum, time, trim, unicode, unique, unixtime, unixtimeformat, uppercase, valid, var, windowfunc, year, zip