Challenge #300: Where is the party?

[Sivashankaran]

Hi Everyone, 

Attaching the solution file for Challenge #300

For Which countries have 2 days of holiday for New Year?

1. Filtering input data with condition for the 2nd January 2019 to see New Year Holiday.

[date] = '2019-01-02'

AND

Contains([english_name], "New Year")

2. Split the Country Code and Country name in separate column.

For What are the countries that don't have New Year's Day as a Holiday?

1. Filter the records which doesn’t have New Year as data.
2. Filter True values and group it by Code_name. For False records, i.e., New Year data records filter for 2019 year
3. Then Left join two values using common column Code_name for appropriate countries that doesn’t have New Year as Holiday.

[Sivashankaran]

Hi Everyone, 

Attaching the solution file for Challenge #300

For Which countries have 2 days of holiday for New Year?

1. Filtering input data with condition for the 2nd January 2019 to see New Year Holiday.

[date] = '2019-01-02'

AND

Contains([english_name], "New Year")

2. Split the Country Code and Country name in separate column.

For What are the countries that don't have New Year's Day as a Holiday?

1. Filter the records which doesn’t have New Year as data.
2. Filter True values and group it by Code_name. For False records, i.e., New Year data records filter for 2019 year
3. Then Left join two values using common column Code_name for appropriate countries that doesn’t have New Year as Holiday.

[brycegrathwohl]

Complete-BG

[bodee8]

Solution

[Ana_S]

My solution 

[Matenco]

-

[LUK-ALTERYX]

My solution attached. 

Regarding 1st question:

2 days off due to New Year's celebration does not equal to countries that have 2nd of January free...

[syn_owiec]

For me the instruction is confusing - I do not understand why the solution in the output file does not take into account countries that start their 2-day holiday the day before New Year's (on New Year's Eve) and additionally excludes Russia, where the second day is called New Year holiday.

2019-01-01 New Year's Day RURussia True True Public
2019-01-02 New Year holiday RURussia True True Public

[krzysztof_zaczek]

Solution

[celinednguyen]

Please see attached!