Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Other way for doing Delta load

I have sample data for initial and delta data in SAP like this

1. Initial Data

PlantProduction  
Order
Production  
Order Type
Production  
Order Type name
CustomerCustomer  
Name
Complete  
Date
Release  
Date
Work   Order
1000110000033242Z110OUTER KCE100001Cust12/8/201121/7/201107091010-03-000
1000110000033240Z110OUTER KCE100001Cust16/8/201121/7/201107091010-01-000
1000110000033241Z110OUTER KCE100001Cust14/8/201121/7/201107091010-02-000
1000110000033830Z110OUTER KCE100003Cust319/8/201128/7/201107229010-01-000
1000110000033866Z110INNER KCE100002Cust28/8/201128/7/201107240010-01-000
1000110000033867Z120INNER KCE100002Cust26/8/201128/7/201107240010-02-000
1000110000033868Z120INNER KCE100002Cust24/8/201128/7/201107240010-03-000
1000110000033869Z120INNER KCE100002Cust24/8/201128/7/201107240010-04-000
1000110000033870Z120INNER KCE100002Cust2 4/8/201128/7/201107240010-05-000
1000110000033871Z120INNER KCE100002Cust25/8/201128/7/201107240010-06-000

2. Delta data

PlantProduction  
Order
Production  
Order Type
Production  
Order Type name
CustomerCustomer  
Name
Complete  
Date
Release  
Date
Work   Order
1000110000033872Z120INNER KCE100002Cust26/8/201130/7/201107240010-04-000
1000110000033870Z120INNER KCE100002Cust2 x28/7/201107240010-05-000
1000110000033873Z120INNER KCE100004Cust46/8/201129/7/201107240010-06-000


I try to replace the orange line in initial data with the orange line in delta data and it works

In Sap, it has a lot of data if I want to update only one line I think it may take a long time right?
so I want to ask 2 questions ....

1. how to delete this line in delta data if it has x in Complete date?

1000110000033870Z120INNER KCE100002Cust2 x28/7/201107240010-05-000


2. how can i replace delta data in other way

Thz so much, very much and too much

0 Replies