Currently trying to implement a cross table expectation that will check whether a specific value matches for a given primary key across two tables.
Example:
table_1 = [(a,1,3000),
(b,0,2000),
(c,0,4000),
(d,1,3000)]
table_2 = [(a,1,3000),
(b,0,2000),
(c,0,2000),
(d,1,3000)]
So if we were to check primary key: a for each table it would return true as the data in the row containing that primary key is the same. However if we check the data in the row with primary key: c it would return false as it does not match.
Currently I’ve tried using the UserConigurableProfiler, but does not give the granualirty/control needed to check this use case specifically.
Any help is appreciated. Thank you.