struggling a little on an iterate

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf struggling a little on an iterate

  • Creator
    Topic
  • #55792
    Lawrence Williams
    Participant

      I am needing to translate an HL7 FT1.19 field to a database schema vrl.

      I am wanting to transform this:

      E10.9^DIABETES 1.5, MANAGED AS TYPE 1^I10~I50.9^CHF (NYHA CLASS II, ACC/AHA STAGE C)^I10~Q60.2^KIDNEY AGENESIS^I10

      To this:

      E10.9^DIABETES 1.5, MANAGED AS TYPE 1^~I50.9^CHF (NYHA CLASS II, ACC/AHA STAGE C)^~Q60.2^KIDNEY AGENESIS

      …basically removing the ICD code set from the field.

      Trying to accomplish this inside an xlt (to keep it simple for future maintenance)… so i built a field iterate and I feel I’m close, but I need to append each iteration to the previous….

      Help me append them together here  ðŸ™‚

    Viewing 2 reply threads
    • Author
      Replies
      • #86513
        Jim Kosloskey
        Participant

          I think you need to include the temp variable @HL7_DX in your CONCAT on the left side (make it first in the list). Also make sure you initialize the temp variable before the ITERATE (COPY @null –> @HL_DX).

          So as you move along you will CONCAT the values TO the temp variable place the updated result in the temp variable.

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • #86514
          Lawrence Williams
          Participant

            You are da man sir !!    Including my temp variable in the Source for the CONCAT worked like a charm.

          • #86515
            Jim Kosloskey
            Participant

              I have to admit I forget that all the time .

              email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

          Viewing 2 reply threads
          • The forum ‘Cloverleaf’ is closed to new topics and replies.