Reloading Recursive Dataflow Data

SamanthaC · 2024-03-29T20:09:04+00:00

There was an error rendering this rich post.

Hello,

I have a recursive data flow running daily adding on and updating our sales data. It was discovered that the join wasn't using a fully unique identifier so some rows of data have been cut out over time. I want to clear out the data and resend it all to domo so that I make sure I have it all. Is there a way to clear out all the rows of data while not deleting the the dataset itself? I have the datasets tied to other dataflows and a ton of cards so I just want to refresh the data but don't want to have to totally rebuild. What's the best way to go about this and getting the missing data added in? Thanks so much!

Find more posts tagged with

Dataset

Magic ETL

Data Flows

Accepted answers

brycec

You'll want to use the data repair feature. Add this exact string to the end of the URL of the DataSet:

?_f=dataRepair

Then, you'll now have a new tab on the DataSet called Data Repair. Navigate to it. Now, you should have all the tools and options to do what you need. It'll let you delete updates, replace updates with a CSV, etc. Then, when you're done, you can remove the feature so people can't mess with the data by adding this string to the end of the URL:

?-_f=dataRepair

GrantSmith

Alternatively you can update your recursive dataflow so your input goes directly to your output, pull in ALL of your data in the input dataset, then change the version of the ETL back to the prior version with the recursion in place.

All comments

brycec

You'll want to use the data repair feature. Add this exact string to the end of the URL of the DataSet:

?_f=dataRepair

?-_f=dataRepair

GrantSmith