DMN rule to validate data reference

BPMN & Modeling Discussion & Questions
1

Can we compare two tables via DMN rule engine? Example : If we have to verify that the row in table A has corresponding row in table B?

2

Hi @Rahul_lodha,

please share more details about your use case, including an example.

What kind of tables?
How do you want to compare these tables? What should be the result?

Best regards,
Philipp

3

By tables I assume you mean tables in a relational database. Unless you absolutely must use a DMN rather use an easy SQL join…

RIGHT EXCLUDING JOIN

This query will return all of the records in the right table (table B) that do not match any records in the left table (table A). This Join is written as follows:

SELECT [select_list]
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key
WHERE A.Key IS NULL
4