How Do I Numformat Multiple Columns?

[TrifactaUsers]

I would like to use the 'Edit Column w/ Formula' function to edit multiple columns at once with the numformat, however, the numformat function requires a column to be inserted in its syntax.

Thanks for any insight.

/s

[Trifacta_Alumni · Accepted solution]

Hi, Steven--

Easy one: use the $col reference wherever you refer to a column name. For multi-column operations, this value is replaced by the specific column name at execution time.

Does that help?

Cheers,

-SteveO