Apply Formula step (within Prepare recipe) to multiple columns?

GSung
Level 3
Apply Formula step (within Prepare recipe) to multiple columns?

Hi, I have a simple 'formula' step (i.e formula = column A - column B), but i would like to apply this same formula to multiple columns. Is there an easy to do that? (as opposed to creating multiple 'formula' steps manually)

1 Reply
fchataigner2
Dataiker

Hi,

the formula step can't be applied to several columns, copying the step is the only way to go. If the formula is translatable to python, you can try using a Python UDF step, since it has a mode to transform a row into another row (so one step can change several cells in one row)

0 Kudos