Replace dataset that has many beastmode calculations

jcorvino
jcorvino ⚪️
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 🔵
    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 🔵

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

    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? 

Categories