Xml tag instead of empty value

malin666 · Post by **malin666** » Fri Jan 20, 2006 9:19 am

Hi,
I am reading xml file

Folder --> XML Input --> Transformer --> Sequential File

At the end for fields (which are empty in source xml file) in targert txt file I am getting xml tag (for instance <firstName/>) instead of empty value.

Any idea how to get rid of such feature?

Regards
Marcin

kumar_s · Post by **kumar_s** » Fri Jan 20, 2006 9:24 am

Hi,

Since you are using Transformer stage next to XML INPUT, i guess you would be in the positon to eliminate this.

Try this post. It might help you.

-Kumar

malin666 · Post by **malin666** » Fri Jan 20, 2006 9:34 am

kumar_s wrote:Hi,

Since you are using Transformer stage next to XML INPUT, i guess you would be in the positon to eliminate this.

Try this post. It might help you.

-Kumar

I don't think that it is the best solution to use basic function for each tag.

The problems is:
- I have well formed source xml
- some of the tags are empty and represented as <tag/> for example <firstName/>
- in target file after transformation, instead of having empty values I have the tag itself..

Thanks
Marcin

shawn_ramsey · Post by **shawn_ramsey** » Fri Jan 20, 2006 10:26 am

Sounds like a bug to me. Have you contacted support?

chulett · Post by **chulett** » Fri Jan 20, 2006 11:02 am

Can't you use one of the Transformation Settings on the Output tab to 'Replace empty values with NULLs'? Seem to recall something like that in the stage...

malin666 · Post by **malin666** » Mon Jan 23, 2006 3:47 am

chulett wrote: Can't you use one of the Transformation Settings on the Output tab to 'Replace empty values with NULLs'? Seem to recall something like that in the stage...

I've tried it before. It doesn't help...

MaheshKumar Sugunaraj · Mon Jan 23, 2006 3:53 am

Could pls check the Meta data of the XML, I had the same problem, so I actually re-imported using the XML Metadata importer and it worked fine.

With Regards
M

malin666 · Post by **malin666** » Mon Jan 23, 2006 6:29 am

MaheshKumar Sugunaraj wrote:Could pls check the Meta data of the XML, I had the same problem, so I actually re-imported using the XML Metadata importer and it worked fine.

With Regards
M

Problem with import indeed. Needed to mark those fields as a text.
Thanks for help

diamondabhi · Post by **diamondabhi** » Tue Jan 24, 2006 10:39 am

Malin666,
Check your column descriptions, do you have /text() at the end of the column description.

Abhi.