The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 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
4 years ago

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).

 

ckattookaran's avatar
ckattookaran
Valued Contributor
4 years ago

Your question was how can I clear the data from workflow profiles, not how can I automate the load process!

Are you saying that there is a method in brapi.import.process to clear the data alone?

  • Mustafa_A's avatar
    Mustafa_A
    Contributor II
    4 years ago

    Oh, apologies if I wasn't clear. 

    Yes, there is...

     

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      Aha, I see it now. ClearStageData