This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm preparing to take the alteryx advanced certification exam so i'm working through the practise questions. Unfortunately i seem to be falling at the first hurdle and wondered if i could have some assistance working through it please? I have attached the data and my attempt below.
You are researching consumption of common food staples globally. In the provided dataset, the average yearly consumption in pounds per person of 15 foods is provided for 236 regions. There are two rows for each region, the header row provides the name of the food and the data row directly beneath it provides the quantity consumed of that food. Determine which region consumes the lowest total quantity of wheat, rice, beans and corn per person. What is that region’s total quantity consumed per person for all four items? (Note: data provided are fictitious and randomly generated) A) 174 pounds per person B) 181 pounds per person C) 196 pounds per person D) 202 pounds per person E) 203 pounds per person
I worked through this myself before checking your version, and we start out exactly the same. However, for the second text-to-columns tool I've split to rows instead, then numbered the rows using a tile tool to match the headers to the data.
I can post my workflow if you want to see it.
I also needed to make changes to the first few steps to handle Guinea-Bissau - you have the same problem.