To participate in the forums you have to register or login.

datacleaner (#1) - Validate using joined tables? (#111) - Message List

Validate using joined tables?

I can't seem to find an example of, or documentation on, how to set up a Validation where two tables need to be joined so values from both can be part of the rule. Is this possible? Can it be extended to 3+ tables if needed?

Thanks, Paul

pwagner
03/12/10 21:42:21
Tree View Flat View (newer first) Flat View (older first)
  • Message #435

    Hi Paul,

    You can't find it because it's currently not possible. One workaround though is to make a database view and run your profile/validation against that view instead.

    One simple "join-like" feature that is available though is pertaining to dictionary matching. It IS possible to create a database dictionary based on a column in a database table and match another table's values against that column. But I appreciate that that may not be what you are looking for. So I would go for the view solution.

    kasper
    03/12/10 23:41:41
Tree View Flat View (newer first) Flat View (older first)