I have Table 1 with the following fields:
I would like to create Table 2 with the following fields:
Please see sample tables attached.
I've tried using the "Summarize" tool to:
I should be getting only the response that has the max no. of incorrect candidates in the "Most frequently chosen incorrect answer" column so that I am getting one row per Question.
Instead, I am still getting multiple rows per question and all the responses are showing rather than just the one with the most frequently chosen incorrect one.
Appreciate any bit of help!
Solved! Go to Solution.
Use a summarize tool and group by the Question and Max Incorrect %. Join that back to the Original table.
Hi @r-alrahmani
You can achieve this by using 2 summarize tools and 2 join tools.
Please check the workflow and please let me know if it worked for you or not.