Skip to Content
0
Former Member
May 12, 2008 at 04:09 PM

xi mapping issue

25 Views

<Header>

<Id dt:dt="i4">270</Id>

<Time dt:dt="dateTime">2008-03-19T08:54:26</Time>

<Node1>

<Amt dt:dt="fixed.14.4">20</Amt>

<IsPIO dt:dt="ui1">1</IsPIO>

<Node3>

<IsOut dt:dt="ui1">1</IsOut>

</Node3>

</Node1>

</Header>

<Header>

<Id dt:dt="i4">272</Id>

<Time dt:dt="dateTime">2008-03-19T09:14:15</Time>

<Node1>

<Amt dt:dt="fixed.14.4">80</Amt>

<IsPIO dt:dt="ui1">1</IsPIO>

<Node3>

<IsOut dt:dt="ui1">1</IsOut>

</Node3>

</Node1>

</Header>

<Header>

<Id dt:dt="i4">271</Id>

<Time dt:dt="dateTime">2008-03-19T08:57:28</Time>

<Node1>

<Amt dt:dt="fixed.14.4">-20</Amt>

<IsPIO dt:dt="ui1">1</IsPIO>

<Node2>

<VTran dt:dt="i4">270</VTran>

</Node2>

<Node3>

<IsOut dt:dt="ui1">1</IsOut>

</Node3>

</Node1>

</Header>

From the above strucutre if Id = NOde2-VTran then SUPPRESS the Header where id = Node2-Vtran else populate Header.

Above is the requirement, could any one help with the UDF code to acheive this. Thanks in advance.