Hey all,
I want to count cases where an article number is just present in one table but not in the other
example
TableV1
ArtNr
1
3
4
5
7
9
TableV2
1
2
3
4
5
6
7
8
9
10
Count cases which are in TableV2 but not in TableV1 (Null).
In that case 2, 6, 8, 10 -> Count = 4
Thx and br
Daniel
Page 1 / 1
Dear Daniel,
thanks for reaching out to the Celonis Community Forum!
Try using the formula:
SUM(CASE WHEN ISNULL(TableV2.ArtNr)=0 AND ISNULL(TableV1.ArtNr)=1 THEN 1.0 ELSE 0.0 END)
This works as soon as there is a common primary key in both tables.
Feel free to follow up with any additional questions.
Best regards,
your Celonis Community Forum Team
thanks for reaching out to the Celonis Community Forum!
Try using the formula:
SUM(CASE WHEN ISNULL(TableV2.ArtNr)=0 AND ISNULL(TableV1.ArtNr)=1 THEN 1.0 ELSE 0.0 END)
This works as soon as there is a common primary key in both tables.
Feel free to follow up with any additional questions.
Best regards,
your Celonis Community Forum Team
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.