Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

Clear data from Workflow import

Hey everyone -    How do I clear data from these workflow manual imports automatically? Right now, I've been going through each month one by one. Wondering if there is a BR that can run them all t...
Data Integration
Import
Mustafa_A's avatar
Mustafa_A
Contributor II

Hi ckattookaran 

I'm not intending to load a blank file. I want the WF to "Clear" data by itself, and run the validation-load steps period by period. 

Last night,  I figured out a different solution and it works. It's mainly defining the workflow (using as WFUnitClusterPk) and using brapi.import.process to execute the various steps (Clear Data, Retransform, Validate, Load).

 

ASides's avatar
ASides
New Contributor II
2 years ago

Hi Mustafa,

 

I am looking to perform something similar. Is the goal of this to entirely clear cube data related to this workflow profile/load? If you are clearing the Stage data, then what is being retransformed/validated/loaded? My understanding is that those steps would fail unless staged data exists.