Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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
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