Page 1 of 1

Seqfile to XML

Posted: Wed Feb 03, 2010 1:42 am
by vinsashi
Hi,
I have one seq file data like this
D:\etl\source\product.txt

pdid pdnm desc
100 100-ab hedroxide

I have to turn this data load into an xml file. I have taken seqfile to xmloutput. I given output filepath (D:\etl\taget\pd.xml) and format.
The job is running with out warning but xml file is not being created at particular path.

Please help me
Thanks
...

Posted: Wed Feb 03, 2010 8:38 am
by eostic
Not sure what steps you have taken on the input link.....the Stage requires that you tell it something about the structure that you want.

For your simple example, try something like this (choose your own names for the node names --- I just made these up) example below. Put these strings on each line of the Input Link grid, into the "Description" property --- one for each of your three columns on the input link:

/AllProducts/Product/pdid/text()
/AllProducts/Product/pdnm/text()
/AllProducts/Product/desc/text()

Mark pdid as a "key" and choose "aggregation" on the output link as your option for generation. You should get a nice looking simple xml document produced.

Ernie

Posted: Wed Feb 03, 2010 11:18 pm
by vinsashi
Now its working
Thanks a lot eostic
......

Posted: Wed Feb 03, 2010 11:29 pm
by ray.wurlod
Please mark this thread as Resolved using the green button at top.