Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

lsmw

Former Member
0 Kudos

hi , friend, i have let 5 row in my flat file,but i want to skip any particular row on certain condition based on par field, as i am using skip_record or skip_transaction , it makes the field blank on which i have used criteria,

tell me how to skip transfer of any par row.

4 REPLIES 4

Former Member
0 Kudos

U can write a code in 5 th step.

while uploading based on the condition...say CONTINUE.

Former Member
0 Kudos

SKIP_RECORD Will skip that record.

skip_transaction : will skip that transaction

so,as per your question,

USE SKIP_RECORD.

if inputfile-field10 is initial.

*--assume if your field10 is empty on any particular record,you dont want to process it

skip_record.

endif.

Message was edited by: Srikanth Kidambi Maruthi

Former Member
0 Kudos

<b>Skip a Record</b>

Situation: You want to "skip" a record depending on a certain condition, i.e. this record shall not be converted and transferred to the output file

Solution:

if <condition>.

skip_record.

endif.

<b>Skip All Records of a Transaction</b>

Situation: You want to "skip" all records of a transaction depending on a certain condition.

Solution:

if <condition>.

skip_transaction.

endif.

Former Member
0 Kudos

In your field mapping, double click on begin_of_transaction and put your logic there and use skip transaction(assuming one record from your file will result in one transaction).

Srinivas