topic Re: Xpath to use alternate element value if preferred value is nilled in Talend Studio

Xpath to use alternate element value if preferred value is nilled

alevy — Thu, 25 Jan 2018 11:29:50 GMT

I'm receiving XML as follows:

I need to extract the PaymentDate if it exists but otherwise substitute the AccountingDate.

Can anyone please help with an Xpath expression that will achieve this for me? (It must be done in the Xpath rather than after the tExtractXMLfield component as the actual parsing logic is externally sourced.)

Re: Xpath to use alternate element value if preferred value is nilled

alevy — Thu, 25 Jan 2018 13:18:32 GMT

Finally solved it after about 4 hours...

concat(substring(PaymentDate,   1 div    (boolean(PaymentDate) and PaymentDate!='')),
       substring(AccountingDate,1 div not(boolean(PaymentDate) and PaymentDate!='')))

(It also caters for the possibility that PaymentDate doesn't exist at all although in my case it always does.)

Now I just need to make it work with three possible dates!

Re: Xpath to use alternate element value if preferred value is nilled

Anonymous — Sun, 28 Jan 2018 03:53:53 GMT

Is that an XPath query ?"concat(substring(PaymentDate,   1 div    (boolean(PaymentDate) and PaymentDate!='')),
       substring(AccountingDate,1 div not(boolean(PaymentDate) and PaymentDate!='')))"

is there any way that we can join multiple fields in a different loop from same XML file ? to get the desired out put ?

Re: Xpath to use alternate element value if preferred value is nilled

alevy — Sun, 28 Jan 2018 03:59:02 GMT

Yes, it is.

You should post a new question, with example of your XML and the result you want to achieve.

Re: Xpath to use alternate element value if preferred value is nilled

Anonymous — Mon, 29 Jan 2018 08:43:37 GMT

Glad to see you back Adam!

Elisa