multipleOBX without iterate counter-add counter, append OBX

[Ganesan Murali]

I

Topic

[Jim Kosloskey]

ITERATE over the OBX assume %g1 as ITERATE Counter/Variable .

Use a MATH Add Xlate Action with:

$%g1

=1

as Source

The OBX-1 field as Destination.

Since the ITERATE Counter is based at zero but you want the Set ID based at one you can simply add one to the ITERATE Counter an get the result you want. That is what the MATH ADD is doing. Using a $ in front of the counter in the Source makes the counter referenceable by Xlate Actions.

To add repetitions not included in the repeating inbound, I would recommend using your own counter – something like %g99 which then you will need to manage.

You can COPY the value of the ITERATE Counter (%g1) to your counter (let’s say %g99) again using the $ technique explained above. Then use %g99 on the Destination address paths (and also use it in the same way as you did %g1 to get the OBX-1 Set ID).

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

[Ganesan Murali]

thanks; Iterate counter works.

But How do we add two hard coded set of OBX’s (2) I can add in the end of original OBX

[Keith McLeod]

Using %g99 from Jim’s response, keep count inside the iterate.  This counter gets predominantly used on the destination side.

Lets say your iterate basis is 0 and your variable is %g1.  Your counter variable we will say is %g99

copy =0 –> $%g99

Iterate Group with basis 0 and variable %g1

  math add $%g1 and =1  –> 0(%g99).OBX(0).#1

  copy 0(%g1).OBX(0).#2 –> 0(%g99).OBX(0).#2

  copy $%g1 –> $%g99

math add $%g99 and =1 –> $%g99

math add $%g99 and =1 –> 0(%g99).OBX(0).#1

…

copy =CULTURE FINDING –> 0(%g99).OBX(0).#5

math add $%g99 and =1 –> $%g99

math add $%g99 and =1 –> 0(%g99).OBX(0).#1

…

copy =FOLLOWUP –> 0(%g99).OBX(0).#5

Use your path, the pattern should be similar…. Notice where %g1 is used vs %g99.  Hope this helps…

[Ganesan Murali]

Thanks Keith & Jim. I couldn’t make it success adding additional OBX’s.

Please find attached the xlt, format, and sample message.

Please help; i’m new to this QDX.  Thanks in advance.

[Jim Kosloskey]

Ganesan,

email me (not PM) and I will assist you off-line.

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

[Author]

Replies