DSXchange

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

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

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

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

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

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

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

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

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

Abhi.