Topic: Validate using joined tables?
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
Thanks, Paul
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.
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.
Log in by clicking the login link at the top of the screen
Go back to forum.
