How to create a rule that checks a flag is unique for a single ID in a table using Infor Steward

[former_member559890]

I want to create a rule that checks if a flag (IND='Y') is unique for each ID in a table (Table_A)

select A.ID,count(*)

from table_A A

where A.IND = 'Y'

group by A.ID

having count(*)>1

I am not sure how to implement this with the advanced editor on Information Steward. Is there any tutorial that helps me understand how to implement complex SQL using INfo Steward.

I am planning to purchase this tool for my org but I am making sure it can serve my quality purpose. My aim is to use this tool to replace complex SQL quality control scripts

[former_member187605 · Accepted solution]

1/. Create a view on Table_A: select A.ID,count(*) from table_A A where A.IND = 'Y' group by A.ID. You can do that in Data Insight > Workspace Home > Manage View > Create View with Join.

2/. Define a simple rule to check wether a value is <= 1. Bind that rule to the count column in the view.

[former_member559890 · Accepted solution]

I have a similar question posted as follows:

https://answers.sap.com/questions/651266/comparing-counts-of-two-tables.html#

Could you help me out with the same please.