cancel
Showing results for 
Search instead for 
Did you mean: 

Routine

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.