Ler tags específicas xml

[rsaraujo_1983]

Qlik Brasil

Boa noite.

tenho uma lista de arquivos xml e preciso:

ler o startTime da tag Phrase se ele for >0 (maior que zero). Porém, se ele for = 0, tenho que ler o primeiro valor de length <>0 dentro da tag <Token> de cada arquivo.

Ex: do Arquivo 1 preciso capturar apenas o "0.385", pois, <Phrase startTime="0.000" endTime="5.605">

    já do Arquivo 2, preciso capturar  "2.645" da tag <Phrase>

Arquivo1:

<?xml version="1.0"?>

<Trans scribe="auto" version="0" version_date="">

<Speakers>

<Speaker id="spk1" name="looser [Telefono] 0" check="no" type="dooo" dialect="native" accent="" scope="local"/>

<Speaker id="spk2" name="looser [Telefono] 1" check="no" type="dooo" dialect="native" accent="" scope="local"/>

<Speaker id="spk3" name="looser [Telefono] 2" check="no" type="dooo" dialect="native" accent="" scope="local"/>

<Speaker id="spk4" name="looser [Telefono] 0" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>

<Speaker id="spk5" name="looser [Telefono] 1" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>

</Speakers>

<Topics>

</Topics>

<Episode program="3dc56f411c1ac0a93cce14c97d1b1f88e49a9a2a428e4843" air_date="">

<Section type="report" startTime="0" endTime="605.22" length="605.220000">

<Turn speaker="spk1" mode="planned" fidelity="high" startTime="0.000" endTime="22.945" channel="studio">

<Phrase startTime="0.000" endTime="5.605">

<Token time="0.000" length="0.385" data="aaaa"/>

<Token time="0.385" length="0.700" data="bbbbb"/>

<Token time="1.085" length="0.230" data="cccc"/>

<Token time="1.315" length="0.400" data="dddd"/>

<Token time="1.715" length="0.180" data="ffffffeeeee"/>

....

Arquivo2:

<?xml version="1.0"?>

<Trans scribe="auto" version="0" version_date="">

<Speakers>

<Speaker id="spk1" name="looser  [Telefono] 0" check="no" type="dooo" dialect="native" accent="" scope="local"/>

<Speaker id="spk2" name="looser  [Telefono] 1" check="no" type="dooo" dialect="native" accent="" scope="local"/>

<Speaker id="spk3" name="looser  [Telefono] 0" check="no" type="fiiiiiiiiii" dialect="native" accent="" scope="local"/>

</Speakers>

<Topics>

</Topics>

<Episode program="3dc56f431d47c0a93cce14cf7d1b1f88e7cb9a2a428c401a" air_date="">

<Section type="report" startTime="0" endTime="73.81" length="78.120000">

<Turn speaker="spk1" mode="planned" fidelity="high" startTime="2.645" endTime="5.145" channel="studio">

<Phrase startTime="2.645" endTime="5.145">

<Token time="2.645" length="0.180" data="oooo"/>

<Token time="2.825" length="0.460" data="yyyyyy"/>

<Token time="3.285" length="0.150" data="uuuuu"/>

<Token time="3.435" length="0.350" data="dddddssss"/>

<Token time="3.785" length="0.130" data="jjjjjjjjjjjj"/>

obrigado a todos.