IMHO, yes, the lookup table is the best way to go. Two ways to implement it.. once you have created the table.. either by extended rules or standard rules.
Both ways are detailed in Gentran's help within the mapper. In your case, I'd lean to standard rule. Think of it this way.. set your output to the "I didn't find it" value, then run the lookup and let the table data overwrite the "I didn't find it" value. If there's nothing in the table then your "I didn't find it" value is already where you want it to be. Good luck.. Richard [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of tbergmann1 Sent: Friday, July 20, 2012 1:19 PM To: [email protected] Subject: [EDI-L] look up tables Happy Friday, everyone. I am using Gentran Server for Windows, version 5.1. I am working on an outbound 856 map where I have to look at a particular app field (store number) and tell the map if it's equal to 15 different values, then write a specific code to the EDI data (i.e. if = to "000015" then (write) "KN") and if it isn't equal then give it another code (i.e. if != to "000015" then (write) "DS"). I have not been able to figure out how to write the extended rule for all 15 values so I thought I'd use a lookup table to tell the translator if the value is in the table, give it the KN code and if not give it the DS code. If the lookup table is the best way to go, how would I write the extended rule to use it? And if the lookup table is not the best way, what would be? Thanks for all your help! I've tried to get this to work so many different ways that my eyes are starting to bug out of my head! ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
