Dynamic field resolusion in Xlate

[Alex Puzikov]

Hi all.

I know it is far fetched but I would like to hear if any one tried something like this.

Problem at hand:

key/value pairs coming in incoming OBX message.

I have a lookup table to identify a key and returning fieldNumber for my Z segment.

I know that conventional metod to do next step is, to create an if statment and then store value.

Which is a big issue if you can recieve large number key/value pairs

Question:

Is any one managed to dynamicaly generate a destination field in Xlate that was derived from variable?

key|value

---

color|red

shape|circle

location|aruba

table mapping

---

color     -> 1

location -> 2

shape    -> 3

result should store

color value in ZF.#1.[0]

location value in ZF.#2.[0]

shape value in ZF.#3.[0]

{ OP COPY }

                                   { ERR 0 }

                                   { IN @value }

                                   { OUT {{0(0).ZF.#@retval.[0]}} }

Thanks.

Alex

Topic

[Jim Kosloskey]

Alex,

Not knowing all the details I offer this:

Make your Z segment field repeating rather than multiple fields, then take the number (base it on zero) from the Table lookup and populate your own iteration counter (field level) and use that counter in the COPY Action for the outbound Z segment field repeition. In my mind, this is an elegant solution and there is no hideen activity. Be sure to comment liberally.

The other option is to write a Tcl proc using xmpstore. You can change virtually anything in the XlatOutList (where the address path of the Outbound field exists).

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

[Author]

Replies