Seven Stars

tXMLMAP namespace issue

Hi,

 

I am extracting data from XML file. Here is the flow.

 

tXMLInput --> tXMLMap --> tFileoutput

 

in tXMLMap i have field from source 

 

[row2.Filename:/POSLog/Transaction/RetailTransaction/LineItem/xyz:YUMBOHTransactionExtensions/xyzSmiley FrustratedpeedOfService/xyzSmiley SurprisedrderSpeedOfService/xyzSmiley FrustratedOSTransaction/xyz:Event/xyz:EventID/@EventName.]

 

while extracting this field i am getting below error.

 

TPrefix0:RetailTransaction/TPrefix0:LineItem/xyz:YUMBOHTransactionExtensions/xyzSmiley FrustratedpeedOfService/xyzSmiley SurprisedrderSpeedOfService/xyzSmiley FrustratedOSTransaction/xyz:Event/xyz:EventID/@EventName.
Exception: XPath expression uses unbound namespace prefix xyz

 

 

Thanks,
Sid
Mark as solution if this resolved your issue
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: tXMLMAP namespace issue

Hi
According to the answer of this related problem, you need to add namespace to xyz.
https://stackoverflow.com/questions/14934178/applying-xpath-on-xml-where-namespaces-are-with-childre...
On tXMLMap, right click on xyz and select 'set a namespace' option to add a namespace. Let me know if it resolves the issue.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
1 REPLY
Community Manager

Re: tXMLMAP namespace issue

Hi
According to the answer of this related problem, you need to add namespace to xyz.
https://stackoverflow.com/questions/14934178/applying-xpath-on-xml-where-namespaces-are-with-childre...
On tXMLMap, right click on xyz and select 'set a namespace' option to add a namespace. Let me know if it resolves the issue.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business