Whole file in one item

[Former Member]

Hi

I am following the below mentioned blog for a requirement and I have two questions :

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

a) In the blog thats given below .. what are the arguments for the given UDF,....in the blog only the code is given .. if i want to use that , how do I create the UDF .... (Queue or Context) and what arguments do i take as input .. is it used in the code somewhere.

b) Also i wanted to ask if I can modify the output (target structure ) to some other structure say :

Target structure should be like

<Header1>

<Field1>Books</Field1>

<Field2>CD</Field2>

<Field3>Video</Field3>

<Field4>Games</Field4>

</ Header1>

<LineItem>

<Field5>CD</Field5>

<Field6>Games</Field6>

<Field7>DVD</Field7>

</LineItem>

Can someone help me with the UDF to achieve that ??

As of now the output is

<ITEMSET>

<ITEM>Books</ITEM>

<ITEM>CD</ITEM>

<ITEM>Video</ITEM>

<ITEM>Games</ITEM>

</ITEMSET>

<ITEMSET>

<ITEM>CD</ITEM>

<ITEM>Games</ITEM>

<ITEM>DVD</ITEM>

</ITEMSET>

thanks

Dev

[former_member200962]

ITEMSET is the input to the UDF...shown in the screenshot above the UDF

[Former Member]

Yes I knw thats the Input but i wanted to know the variable name used as an argument for the functions , is it arrayItemset ?

And can you please suggest something for the 2nd part of the post .. i need some help with the UDF ??

[former_member200962]

Can you look at the comments section once....Sravya's comment quite valid.....is there any compulsion of using UDF?