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

OS_Love's avatar
OS_Love
New Contributor III
2 years ago

WF Import

I am trying to load 3 data files via 3 import step within same WF.

What I see is the last imported data replace the data in the cube for the same intersection.

I want the data files to sum up instead of replacing with the last loaded file.

What is the way to do this?

I cannot use the same import step - as one of the import has a parser rule running which I dont want to run for the other load file.

Please advise.

Data Integration

4 Replies

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    OS_Love  - Coupe of ways 

    1. Using WF Channel - Define WF channel for each WF Import because when you try to load to the cube it will clear and load. using WF channel (level 4 DU) it will clear only that particular intersection.

    2.  Set the below settings in WF. Import one should be replace and other 2 Import should be append.

     

     

     

  • Niki's avatar
    Niki
    New Contributor
    2 years ago

    Is data being loaded using different Source Ids?

  • Cecilia's avatar
    Cecilia
    New Contributor II
    2 years ago

     Are you doing a Import - validate- load?  Can you confirm the 3 SI# that you are using?