Challenge #169: Women's World Cup Wins

[jaquilinejoy595]

[pavan20085]

Solved the weekly challenge - My first one!!!

1. Select Tool to convert score columns to numbers

2. Formula tool to create a new column "Value" to identify Winner or Draw

3. Sorting the data

4. Summarize Tool to Group by "Value" and Count by "Value"

5. Filter out Draw

6. Sample Tool for first row - Solution Arrived

Feeling Great!!

Thank You.

[ShankerV]

Nice one!!!

Little tricky too!!!

Was able be to reach solutions is multiple ways!!!

[jjimenez]

How do I upload the data file provided onto the canvas? 

[ShankerV]

Hi @jjimenez 

The input file is given as an .txt file

You need to add a input tool in the canvas

With the help of the configuration pane of Input tool, you need to try to browse the folder and link the downloaded .txt file

This will input the file, however change the input file as .csv in the configuration pane

Also the delimiter should be used as /t 

This will help to input the file also create separate columns.

[ShankerV]

Hi @jjimenez 

The input file is given as an .txt file

You need to add a input tool in the canvas

With the help of the configuration pane of Input tool, you need to try to browse the folder and link the downloaded .txt file

This will input the file, however change the input file as .csv in the configuration pane

Also the delimiter should be used as /t 

This will help to input the file also create separate columns.

[jjimenez]

Thank you for your help. Unfortunately, when I do that, I get the below

[joeoswald614]

Spoiler

[KimishaP]

Another great challenge

[IraWatt]

Great challenge !

Spoiler