Skip to Content
0
Jul 25, 2016 at 01:29 PM

To create a line item in the file only if one of the condition from source idoc is true.

60 Views

Hi All,

I have a Idoc to csv file scenario.

In my idoc have a segment E1WXX01(it can occur n number of times) where it contains the fields FLDGRP, FLDNAME and FLDVALUE.

If FLDGRP = "MARA" and FLDNAME = "TRUE" and FLDVAL = "Y" then only that line item should come or else it should not come. Not all the E1WXX01 segment contains exactly these values, it varies so if any of the E1WXX01 segment contains these values then the line item should populate.

My source structure:

Idoc:

EDI_DC40--->E1WPA01(1:1)---->E1WXX01(1:unbounded)

CSV file format:

Data1

Item,3154,1,TRUE,1,0

Item,2674,1,FALSE,1,0

Item,8908,1,TRUE,1,0

so, in my case now only first and third line items should come second should not populate at all. I am unable to use create if function due to context changes. How can I get the target file as expected?

Thanks in Advance.