Challenge #491: Behind the Blockbusters

[Yoshiro_Fujimori]

My solution.

Spoiler

For Task 1, if I apply "1224" ranking method, there are 16 records within "top 10".
For Task 3, I would use count distinct for iso country code.

Workflow

By the way, I encountered an issue in Input Data Tool which reads tmdb_5000_movies.csv.
It works on the "Original Engine" without problem.
However, when I switch the workflow to "Use AMP Engine", I see the errors;
  "CSVFile: A field was missing a closing quote in record 3030: ... "

The error disappears with turning on "AMP Only: Allow Newlines in Quoted Fields" option in the Input Data Tool.
Today I learned the reason of existence of this option.😀

[alrcuenca]

I was getting 86 languages for Step 3 when filtering via "iso_639_1".
I also noticed some of the "names" have unicode characters but the result for that is 26.

If you include the null in the count it'll be 87 or 27.

Spoiler

[josephmadigan]

Updated my flow using Yoshiro's engine fix. All match (except for budget ties, which I consider to be an equivalently correct output)

Also, I feel like tokenized parse -> rows for this specific case is a much simpler solution than many of the JSON filters I've seen while peering through solutions. Wondering if there is a reason for the JSON searches that I'm not considering or if many people are just used to thinking this way from working with JSON syntax to construct objects.

[annbriceAB]

A fun challenge!

[alexnajm]

Done - same issues as most though

Spoiler

[Tej_Singh]

Soution. Answer for Q3 should be 87 and not 27

[Mamundankar]

my answer of 3 part are incorrect..i have tried to solve by simple parse function

[axelfalck]

[wbasuki]

Firstly, I have different result for task 3. The I have updated after I read reply from SylviaP (Moderator). Thanks for the clue.

Spoiler