Concat and Iterate

Mark,

Looks like the loop is overwriting the value with each iteration. May be your should copy the OBR.4 values to a variable, and then concat the variable to the PV1.5 field.

Thanks.

You can refer to the output value in your source list for the CONCAT.  I think the following should work.  You may need to null out PV1.5 before hand depending on what happened earlier in your Xlate.

Hope this helps,

Mark,

By referencing the output value, it takes what has been previously mapped to that field and uses it as a source value.   One thing you need to remember though is that if you are using bulkcopy or pathcopy on the PV1 segment BEFORE you hit your iteration, then there is a chance that PV1.5 may be mapped with data that you don’t need or want.   Unless you want to include that data along with that of your iteration, then you will need to do some checking to make sure that the PV1.5 isn’t populated with unwanted data first.

Also, if it is necessary to keep the data in PV1.5 in the same order in which it came out of the OBR.4, then you will need to modify the CONCAT as such:

CONCAT

Source

~0(0).PV1(0).#5(0)      —>(~ means use the output value)

2(%g1).1(0).0(0).OBR(0).#4(0).[0]

Destination

0(0).PV1(0).#5(0)

Hope this helps….

Tom Rioux

Are you wanting to run each individual OBR.4 value through a table and then take that resulting output and concat it to the PV1.5 value?  If so, try something like this:

ITERATE

   COPY  (to initialize the variable with each iteration)

       Source        @null

       Destination  @route1

   TABLE  {pathor}

       Source        2(%g1).1(0).0(0).OBR(0).#4(0).[0]

       Destination  @route1

   CONCAT

       Source        ~0(0).PV1(0).#5(0)

                         @route1

       Destination  0(0).PV1(0).#5(0)

Let me know if this works for you or if you are wanting something totally different.

Hope this helps…

Tom Rioux