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

Options
GSung
GSung Registered Posts: 27 ✭✭✭✭

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)

Answers

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker
    Options

    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)

Setup Info
    Tags
      Help me…