Replace dataset that has many beastmode calculations

Options
jcorvino
jcorvino Member
in Magic ETL

Have a very large dataset (5M rows) from a connector that we need to clean up by exporting the data, de-duping and replacing the dataset. The dataset has a large number of saved beast mode calculations (2 dozen). Will the beast mode caculations be preserved when we reload the data? 

Best Answer

  • AS
    AS Coach
    Answer ✓

    I'm unaware of a way to replace a separate datasource via Excel.  Uploading via Excel would end up creating a new dataset, which means the beast modes wouldn't carry over.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • AS
    AS Coach

    Beast modes are saved to the dataset regardless of the number of rows in the dataset.  As long as the data you reload replaces exactly the same dataset, and isn't a swap for a new dataset, then yes, the beast modes will remain.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • jcorvino
    jcorvino Member

    Thanks. One more wrinkle.

     

    The original dataset was created and is updated daily by the Five9 connector. The plan is to export it to a csv, dedup the csv, reload it with workbench and then have the connector continue to append rows daily. Does that add any issues? 

  • AS
    AS Coach
    Answer ✓

    I'm unaware of a way to replace a separate datasource via Excel.  Uploading via Excel would end up creating a new dataset, which means the beast modes wouldn't carry over.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories