Seqfile to XML

vinsashi · Post by **vinsashi** » Wed Feb 03, 2010 1:42 am

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
...

eostic · Post by **eostic** » Wed Feb 03, 2010 8:38 am

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

vinsashi · Post by **vinsashi** » Wed Feb 03, 2010 11:18 pm

Now its working
Thanks a lot eostic
......

ray.wurlod · Post by **ray.wurlod** » Wed Feb 03, 2010 11:29 pm

Please mark this thread as Resolved using the green button at top.