Passing value through table with no match

[Sloan Manning]

How can I get a table in a translation to pass my original value through if there is no corresponding  value on the table.   I blanks out that portion of the message, and I need to be able to just pass through the original value.

Topic

[Sloan Manning]

Forgot to list that I am using 5.7 Rev2 .

[James Cobane]

Sloan,

I can’t recall, but does 5.7 have the “Use original value” option in the Table Configurator?  I thought this became available in 5.6, but maybe it isn’t until 5.8.  If that option is not available, you can simply do an IF statement after your table look-up to check if the output field is valued, and if it is null, COPY the original input field to the output field.

Hope this helps.

Jim Cobane

Henry Ford Health

[Sloan Manning]

James Cobane wrote:

Sloan,

I can’t recall, but does 5.7 have the “Use original value” option in the Table Configurator?

[Jim Kosloskey]

If you are using the IF technique just remember you are checking for what is in your default in the table – if that is null then check for null if your default is something else use that.

I have a proc I have used that is designed to allow dynamically naming the Table and has an artifact which allows preserving the inbound value if wanted should the default result from the lookup.

There has been an outstanding request for some time for the Xlate to allow dynamically specifying the Table to use bur since that has not yet happened I wrote the proc (needed it for an X12 project and has come in handy for others).

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

[Author]

Replies