Skip to Content
avatar image
Former Member

target node need to be repeated based on the output value of the UDF

Hi Gurus,

I have the requirment to get the multiple records from the DB in UDF based on the single input value. I have to generate multiple occurance of the target node based on the output value of the UDF. I will explain with simple example

My input structure contains single field

Students_details

Classname

Student_details

In my UDF, i have accessing the DB using Database Accessor

The input value for the Classname is 5, then my UDF get all the student details of class 5.

My output structure should be

Student_Det

Student

roll no: 1

name: raj

average: 80

Student

Student

roll no: 1

name: raj

average: 80

Student

Student

roll no: 2

name: rajasekar

average: 40

Student

Student

roll no: 3

name: raja

average:90

Student

Student_Det

But the target node Student is not repeating. i ll get only one node in the output. My source Que contains single Context change. I have try to add the Context change after each value in the UDF using 'result.addValue(ResultList.CC);'

I have tried with Splitby value functionality. still its not repeating.. pls guide me

Regards,

Ramalakshmi.G

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 08, 2011 at 08:39 AM

    Hi,

    Have you checked the occurance of the target message type?

    Is it 0...Unbounded? Make sure it is 0....Unbounded.

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2011 at 08:43 AM

    Hi,

    >>>But the target node Student is not repeating

    what is the occurrence of student node...it should be 0...unbounded

    Regards,

    Priyanka

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2011 at 08:55 AM

    Yes. Its occurance is 0..Unbounded only.. My input queue contains only one input.. but the output queue contains multiple record.. that also i need to generate from the UDF..

    I can see the Queue value as..

    11

    CC

    22

    CC

    33

    CC

    44

    CC

    But still its not prducing multiple target node. I have mapped this roll number to the target node student

    Regards,

    Ramalakshmi.G

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2011 at 09:08 AM

    Is your UDF returning multiple occurances of data with context changes?

    check that by testing your UDF...by writing the output and incorporate the context change..also see the occurance of your target node.

    Add comment
    10|10000 characters needed characters exceeded