struggling a little on an iterate

Homepage 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.

Forum Statistics

Registered Users
5,117
Forums
28
Topics
9,292
Replies
34,435
Topic Tags
286
Empty Topic Tags
10