Cloud Quest #2: Consumer Purchase Aggregation

[DavidSkaife]

Here's my solution

Spoiler

[Yoshiro_Fujimori]

The expected result is

Total Orders	Potential Meal Deal	Percentage
14450	10221	70.73

while my output is

Total Orders	Potential Meal Deal	Percentage
15497	10964	70.75

I tried on both "Standard Mode" and "Cloud Native Mode", and

I found that the expect result above was displayed on the workflow created with Cloud Native Mode,

and my output above was displayed on the workflow created with Standard Mode.

After running the workflow, the csv file was the same as my output (Total Orders 15497) on both mode.

I think I would use Standard Mode for all the time,

but according to the  description of "?" button on the Designer Cloud screen:

Cloud Native : Cloud Native Mode is optimized for Cloud Data Warehouse execution, which allows for the processing of large datasets.
Standard : Standard Mode allows for access to the full dataset at design time, similar to Designer Desktop, and is powered by the Alteryx AMP Engine.

So, should I switch to Cloud Native Mode in dealing with large datasets?

Workflow

Spoiler

The flow is the same for both Standard Mode and Cloud Native Mode.

[JoshuaB]

Posting for Points!

[Kilbyflow_Designer]

Quest complete!!!

Spoiler

 

[abacon]

@Yoshiro_Fujimori your advice helped me figure out why my outputs weren't matching, thank you!

Here is my solution.

Spoiler