Skip to main content
W
Wikus
February 21, 2024
Solved

Transformation rules mappings

  • February 21, 2024
  • 3 replies
  • 0 views

Does anybody know in which table are Transformation rules mapping stored?

Thanks

Best answer by MarcusH

This is the query I use for exporting maps (this does not include logical operators or expressions)

SELECT 
    Case Ruletype
        WHEN 1 THEN 'OneToOne'
        WHEN 2 THEN 'Composite'
        WHEN 3 THEN 'Range'
        WHEN 4 THEN 'List'
        WHEN 5 THEN 'Mask'
    END AS MapType
    ,RuleName
    ,RuleDescription
    ,Case Ruletype
        WHEN 1 THEN RuleName
        ELSE RuleExpression
    END AS Source
    ,OutputValue AS Target
    ,Case FlipSign WHEN 0 THEN 'False' ELSE 'True' END AS FlipSign
    ,ExecutionOrder AS [Order]
 FROM StageRuleGroups
 INNER JOIN StageRules ON StageRules.RulesGroupKey = StageRuleGroups.UniqueID
 WHERE RuleGroupName = 'MyRuleName'
 ORDER BY RuleType, ExecutionOrder, RuleName

 

3 replies

M
MarcusH
February 21, 2024

The maps are held in the table StageRules.

D
DanielWillis
Employee
February 21, 2024

Often joined with StageRuleGroups, e.g., to get a list:

 

SELECT 
    Case Ruletype
        WHEN 1 THEN RuleName -- 1:1
        WHEN 2 THEN RuleExpression -- composite
        WHEN 5 THEN RuleExpression -- mask
    END AS Source,
    OutputValue AS Target
 FROM StageRuleGroups
 INNER JOIN StageRules ON StageRules.RulesGroupKey = StageRuleGroups.UniqueID
 WHERE RuleGroupName = 'MyRuleName'

Just grabbed this from somewhere without checking but it looks right!

W
WikusAuthor
February 22, 2024

Hi Daniel,

Thank you for the reply, looks good to me.

W
WikusAuthor
February 22, 2024

Thank you Marcus this will work for me.

Terms & ConditionsAccessibility statement