Skip to Content
0
Jan 30, 2014 at 10:38 AM

Context change UDF

104 Views

Hi,

I have a requierement that file will be received in the below format.

But in Target structure Header should be populated based on the group of fields "a" and "c" where in "a" field should be uniquely considered. i.e. Header should come 4 times.

Please suggest if this can be achieved through Graphical mapping? if not please help me with the UDF.

Thank you.

<Deatils>
<a>13thNov</a>
<b>23</b>
<c>1.1</c>
<d>101</d>
</Details>
<Deatils>
<a>14thNov</a>
<b>21</b>
<c>1.2</c>
<d>101</d>
</Details>
<Deatils>
<a>14thNov</a>
<b>23</b>
<c>1.1</c>
<d>102</d>
</Details>
<Deatils>
<a>15thNov</a>
<b>23</b>
<c>1.1</c>
<d>101</d>
</Details>
<Deatils>
<a>15thNov</a>
<b>23</b>
<c>1.1</c>
<d>101</d>
</Details>
<Deatils>
<a>16thNov</a>
<b>23</b>
<c>1.1</c>
<d>101</d>
</Details>