Forum Discussion
AdministratorCount 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 responses.
and this is the specific answers that must be found, for example from the previous table how many response IDs walamrt have in c4 and automercado in c1.5 and so on with each of the rows in this second table
I leave an example GDP https://drive.google.com/file/d/1RL-iWsD5yiWLTT7dSRP48O9IZn-8Wklk/view?usp=drive_link
4 Replies
Please provide more detailed description.
Actually that I can't understand the requirement that you post completely.
If possible, please provide your expected result with backend logic and special examples.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.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
ryan_mayuSuper User
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?
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
