Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Count how many IDs meet two requirements

Nice day I require your help as I want to count in a table that brings ID and for each ID many answers from these cules ID meet two specific answers This is the table that contains the IDs and resp...
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Syndicate_Admin 

the link can't open.

Do you mean, if an SbjNum's PERCEPCION(Estudio) has both C1.5 and C4, that ID count as 1?

what's the expected output based on the sample data you provided?

 

3XotiC's avatar
3XotiC
Frequent Visitor
2 years ago

Each combination found in the first table would be counted as 1, and each combination that is required is described in table 2.

 

For example, if the id "203522243" in all your answers is c4 walmart and c1.5 automercado it would be considered 1

 

The result is presented in a table like this, being the advance counts combinations found