Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
For the Visual Recipe Test, one of the questions is as follows:
Which of the following must be defined when creating a Pivot recipe? (Select two.)
Let's say that you want to find distinct values of two columns in a dataset. If using the Distinct recipe without computing counts of deduplicated rows, how many columns will be in the output dataset?
Hi @PhilipBF , I can suggest trying to run Pivot recipes without each of the possible answers and see which are absolutely required and which are (most often present but) not actually required.
Hi @SeanA, I tried that, but it seems like there's no answer. I didn't fill in anything for any of them. For the row identifier, Data Iku says Nothing selected, output will be a single row. Does that mean a row identifier isn't required because it will be selected anyway?
@SeanA @, row identifier was the answer. Thank you for your help. I asked the person responsible to fix the course, since the tutorial is misleading.
Hi @PhilipBF , thank you for your feedback. I think the question is trying to draw your attention to how the row identifier works. It can be helpful to have a mental model of how the output will be impacted having 0, 1, or even multiple row identifiers.
Hi @SeanA, thank you for explaining the concept and for your help.