on 04-12-2007 9:37 AM
have totally 5 evaluation criteria data out like Price(01), Quality(02), Service(03)
& its score & for this I have the subcriterions
Now I have to pick only evaluation criteria data of Price and service & subcriterions of Price and service only & its score but I should not pick the data of evaluation criteria Quality & its subcriterions in to BW
for this i have written a start routine in transfer rules like this
delete datapak where HKRIT ='02'.
delete datapak where TKRIT = '1' OR TKRIT = '2' OR TKRIT ='3' OR TKRIT =
'4' OR TKRIT ='5'.
but Number of data records changed form 206 to 0 in start routine
Hi,
With statement
delete datapak where TKRIT = '1' OR TKRIT = '2' OR TKRIT ='3' OR TKRIT =
'4' OR TKRIT ='5'.
you are deleting all records without any respect on HKRIT, i.e. also '01' and '03' are
deleted when a record contains any defined TKRIT.
Please try this
delete datapak where HKRIT ='02' and ( TKRIT = '1' OR TKRIT = '2' OR TKRIT ='3' OR TKRIT ='4' OR TKRIT ='5' )
Hope this helps
Joe.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.