I have a series of different articles. Each article is described by a number of features. Articles that belong to the same family always have the same set of features. To each family a template is assigned. This following table reflects that relationship. 'X' means that in the article's description that particular feature is used (with it's value)!
Template Length Width Thread Form Diameter Process Thickness Transition
----------------------------------------------------------------------------------------------------------------------------
TemplateA X X X X
TemplateB X X X X
TemplateC X X X X
The article description is a text column that lists up these features using a comma delimiter:
Description = 'Width: 20 mm, Thread: metric, Form: conic, Transition: step'
I can't find an expression that returns the correct template for a given Description. In this case: TemplateB
I transformed the description into a table using dynamic SQL, that has the column names Width, Thread, Form and Transition but I can't see to join these tables in order to get the template name.
Any hints?
Martin