Forum Discussion
Difficult comparison
Hi, I have a dataset like: ID Code Check1 Check2 1 100 T F 1 100 T F 1 100 T F 1 200 F T 1 200 F F 2 100 T T 2 200 T F 2 200 T F 3 1...
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous,
If Code is 100, Either Check 1 or Check 2 is T (in every record), then overall check for code 100 with be "T" for that ID.
If Code is 200, then atleast one row should have "T" in check 1 or check 2, this will make code 200 as "T".
I'm still a little confused about your requirement. Is the two centence above your descrption for your data table?
And your requirement is to check if the ID is T or F?
Could you share your expected output as visual so that we could understand your requirement better?
Best Regards,
Cherry