WF Import

Forum|Forum|2 years ago
April 25, 2024
4 replies
0 views

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

Is data being loaded using different Source Ids?

Yes- diff source id

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

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.