topic How to get tExtractXmlField to include both xml sibling items not just one in Talend Studio

How to get tExtractXmlField to include both xml sibling items not just one

DaveTaylor — Tue, 22 Aug 2017 00:26:35 GMT

I call a service and get back a payload (abbreviated) like this:

I use a tExtractXmlField component to pull out the data; into a respository metadata like this:
isSubscribed String
multipleTimesPerDay String

I have tried changing the Datatype from String, to Object, to List; and I always just get the first item/value.

What I would like to get is:

columns
isSubscribed multipleTimesPerDay
"true" "07:19:32", "06:09:32"

I want the multipleTimesPerDay values in one column in the metadata repository; that I can evaluate later.

What am I missing?

Re: How to get tExtractXmlField to include both xml sibling items not just one

DaveTaylor — Tue, 22 Aug 2017 21:17:05 GMT

Found a work around.
Added a tAggregateRow component, with the output column as 'multipleTimesPerDay' function list(object)
and set the output datatype for that column as List.
Works well.

Re: How to get tExtractXmlField to include both xml sibling items not just one

SachinD — Wed, 23 Aug 2017 05:35:14 GMT

I tried using tXMLMap, and got multipleTimesPerDay, let me know if it helps you @DaveTaylor.

Please refer attached screenshots

Thanks,

Sachin D.