A solution to last week’s challenge can be found here. Source: https://www.gardenista.com/posts/flower-arranging-101-a-crash-course-for-the-uninitiated/
A florist is making 10 flower arrangements for a party. He'd like to maximize the total number of flowers in each arrangement.
The florist has picked out the seven different kinds of flowers he'd like to include in each arrangement. Each arrangement needs to have between 4 - 8 of each flower, and between 3 - 4 filler greens.
His budget is $950. How many of each flower should the florist order?
... View more
Last week's solution has been posted HERE.
A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if a course ends at 16:30, he would like it to show as 4:30. He also wants to know what the elapsed time is between the two fields mentioned above. How long is each course? Minutes will be the time unit measured.
... View more
Last week's challenge can be found HERE!
You have been given some order information that contains a list of orders with SKUs and related quantities. Additionally, you have a data set with the total inventory for each SKU.
You have been tasked with figuring out how to consume all of the inventory with the least amount of orders. In other words, you have been asked to fill the largest orders for each SKU in descending order.
Additionally, only complete orders may be fulfilled. For example, if an order calls for 4 units of a SKU, and only 3 are left in inventory, you can't fulfill the order.
... View more
A solution to last week’s challenge can be found here.
Welcome to a special Weekly Challenge where we will send you on a scavenger hunt to find a hidden word!
This week the Alteryx Certification Team has put together a special challenge that will put your Core skills to the test! Using a dataset compiling a portion of the Core Certification passing exam attempts from the past two years, you will solve 7 clues to find the hidden word. And then, with the Bonus Challenge discover the ultimate message from the Certification team.
This dataset represents Community users from all over the world that have passed the Core Certification exam and earned their Core Badge. (Percentages have been randomly generated, they are not actual exam results.)
Hint
For each clue you answer, make sure to label the column "Answer".
Good luck!
... View more
A solution to last week's challenge can be found here.
In celebration of the Data Connections window and many other cool new features in the 2019.3 release, this challenge requires you to read in thousands of files across 15 different file formats: yxdb, sz, avro, csv, shp, gml, sav, json, mif, tab, xlsx, xlsm, qvx, sas7bdat, geo. Each file contains a single value. Report back the sum of all values.
Hint: suffix FileFormat yxdb 19 sz 16 avro 48 csv 0 shp 12 gml 31 sav 46 json 54 mif 10 tab 14 xlsx 25 xlsm 56 qvx 47 sas7bdat 45 geo 15
... View more
