Skip to Content

Mapping Doubt. How to remove SUPPRESS

HI All.

I want to remove the Suppress which is coming result of CreateIf.

even i tried UDFs which is available in other threads.

first i tried to remove the SUPPRESS using blow code

and the result is, it not removing the SUPPRESS, and in place of suppress i'm getting null.

and aging i tried one more UDF to remove the null which is available in other thread as mentioned below.

and now i can able to remove the SUPPRESS but it's not giving the proper count of values, it's giving only one output for every context change.

based on this example expected result is

[]

[]

context change

[]

[]

context change

[]

[]

context change

please do needful.

Thanks and regards.

a1.JPG (117.9 kB)
a2.JPG (196.8 kB)
a3.JPG (200.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Apr 08, 2016 at 10:16 AM

    Hi Ramesh,

    Use below mapping after remove contexts in your mapping logic.

    REC_TYPE equals to EMPLOYEE --->removeContexts--->UDF--->employees(Node)

    UDF:

    Execution Type: All Values Of Context.

    public void mapEmployeeNode(String[] input, ResultList result, Container container) throws StreamTransformationException {
      for (int i = 0; i < input.length; i++) {
      if (input[i].equals("false")) {
      if (i != 0)
      result.addContextChange();
      } else
      result.addValue("");
      }
      }
    
    

    Regards,

    Praveen.


    mapping.png (19.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 08, 2016 at 10:30 AM

    Hi Ramesh,

    you can try this logic

    rec type

    ----UDF1----- remove suppress UDF---splitbyby value(value chnage)-----target

    Employe

    udf1:

    UDF2:for deleteing suppress u can use ur udf .

    try the above mapping logic and let me know if u have any issues

    Thanks

    Kavitha


    udf1.PNG (10.2 kB)
    udf2.PNG (18.4 kB)
    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.