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

GSung
GSung Registered Posts: 27 ✭✭✭✭
in General Discussion

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)

· Share on FacebookShare on Twitter

Answers

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 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)

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…