0 Replies Latest reply: Aug 15, 2018 7:22 AM by Adam Smith RSS

    Querying XML

    Adam Smith

      Hi All,

       

      ASD.png

       

      Above is my XML which I have been able to query to a certain point. However, I am having trouble linking the "CP" element back to the RId.

       

      How would you get the RId?

       

      My XML Query looks like;

       

      XMLOutput:

      Load

      RId as RatingJoin,

      PIncIPT ,

      PExIPT ,

      PIncIPT - PExIPT,

       

      From_Field('Policy','RD') (xmlSimple, table is [RatingData]);

       

      CPOutput:

      Load

      [RatingData/RId],

      I as [True/False],

      V

       

      From_Field ('Policy','RD') (xmlSimple, table is [RatingData/CP/CPI])

      where I = 'true'

       

      but for the life of me, I cannot join CPOutput to join back to the RatingData XMLQuery.....