How do I delete records in an ETL data flow?

Good Day,

 

I have an ETL data flow that is recursive in nature updating Google Analytics data on a daily basis.  A subset of data was missing so I appended another dataset in the flow which was ultimately in error.  I am attempting to delete the data which was ultimately in error and replace it with new data.  I'm not sure how to delete records that are now in my data set.  

 

Thanks so much for any help.  

Comments

  • Could you use a filter to grab the records that are incorrect and filter them out? 

     

    The use of filters is the only way I would know to remove items from a dataset.

     

    You would end up with a new output, but that new output could then be used as your new base dataset.

     

    Hope that was of some help,

    Valiant