Skip to Content
0
Former Member
Jun 02, 2008 at 08:37 PM

Help Needed: Syndicate Single Qualified Value

28 Views

Hello,

I am having a problem understanding how to do the following in MDM 5.5 sp05:

I have a qualified table named "Classifications". I am using this table to associate name/value pairs with my products. The information is coming from an R/3 source. The Classification Type (the non-qualifier) is a lookup that has values like "FDA Drug", "Flash Point", "Latex Product". Classification Code is the qualifier and stores the value - could be "Yes", "No", etc.

Not every product is going to have all of these classifications, and that leads to my difficulty. I need to syndicate out a subset of products to a customer (achieved by setting a multi-valued lookup field) and I want to include the Classification Code for "Latex Product". I DO NOT want the other non-qualifiers to appear in the file. Also, if a product does not have a "Latex Product" classification, I still want to include it in the syndication.

I cannot figure out how to do this in Syndicator. I guess an alternative would be to create a calculated field (or assignment field) in the Products table that gets the code value from the qualified table. But I cannot figure out how to do this either.

Thanks in advance.