Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

check for relation with other table

I want to check if there is one (or more) row(s) in another table (table2), with a relation to the first table. I've found a soltion which I've tryed in my ow model but now I get the error: - The fu...
Need Help
Johanno's avatar
Johanno
Icon for Continued Contributor rankContinued Contributor
7 years ago

Hi, you could get a list of all records that exists in both tables if they are related with:

Number of rows in the related table = CALCULATE(COUNTROWS('Table1');RELATEDTABLE('Table2'))

Would that work for you?