How to show record once for multiple occurance

[Former Member]

Hi,

i have a record whose occurance is ' * '.But to the output i need to only map the value of the field which comes in the first occurance of the record.Can anyone help me in this.its very urgent.

For ex :

my input is

Hi I have following structure .and using graphical mapping

<header>

-

---

<inp1>123</inp1>

-

---

<inp2>hello</inp1>

</header>

<header>

-

---

<inp1>456</inp1>

-

---

<inp2>hello</inp1>

</header>

In output I want to display inp2 i.e Hello only once. How can I do this

[Former Member · Accepted solution]

Hi,

You can do this by using graphical mapping. You can write UDF and by using context you can select always first record / whichever record you want to output.

Nilesh

[VijayKonam · Accepted solution]

Use the node function - Remove Contexts and then Collapse Contexts.

VJ