WF Import

[OS_Love]

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.

[Niki]

Is data being loaded using different Source Ids?

[OS_Love]

Yes- diff source id

[Cecilia]

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

[Krishna]

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