Skip to Content

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 25, 2016 at 05:43 PM

    Just change the context of fields FLDGRP , FLDNAME and FLDVAL to E1WPA01 in your mapping.

    Br,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 02:14 PM

    Hello Richa,

    Can you post the queue and context ,might be you can use If else and node functions to achieve the same.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.