How can I apply a sequence of "Preparation" steps I have made for one dataset to another

UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
I have several datasets where some of the columns are identical (for ex. Country, Product-name), but otherwise differs. I need to prepare them before analysing and eventually merging them, in order to make sure that rows with the same values for Country and Product-name can be matched. Now that I have defined a set of replacements and filters for one of them, I would like to apply these to the other data set(s) without having to start from scratch every time. Is there a (simple) way to do this?

Best Answer


  • cperdigou
    cperdigou Alpha Tester, Dataiker Alumni Posts: 115 ✭✭✭✭✭✭✭
    Two ways:

    - Stack all your datasets with a stack recipe and do a single prepare recipe.

    - Copy the prepare recipe (got to flow, click on the recipe, it's one of the actions on the right) as many times as needed. (looks more adapted to your use case)

    A drawback of the second method is that if you change one recipe, you have to propagate changes to others manually.
Setup Info
      Help me…