Excluding a particular record in a file depending upon a field value

[Former Member]

Hi ,

I have a requriment where i need to exclude particular records depending on a filed value

i am picking a file from ftp which consists of more than 800 records, i need to exclude particular records where salesordernumber field consists of text instead of numerics, how can i write condition for this?

Thanks in advance,

Nousheen

[Former Member]

Hi,

Declare a flag value is false at starting when your condition occur make that value as true. In if condition mention if flag = true skip that line(out side the loop).

Use flag logic.

Thanks,

RamuV

[Former Member]

You can check this in Mapping itself

in mapping use UDF to check if salesordernumber field contains numbers only.. if yes then return true, then use ifWithoutElse to check this flag value, if true then only set corresponding target element