Input.xlsx|||<List of Sheet Names>
False
1
Input.xlsx
Query=<List of Sheet Names>
Costa Rica
2015
El Salvador
2030
Bolivia (Estado Plurinacional de/ Plurinational State of)
YES
República Dominicana / Dominican Republic
2015
Cuba
YES
Ecuador
YES
Guatemala
YES
Honduras
YES
Paraguay
YES
Perú
YES
C:\Users\Esther Bezborodko\OneDrive - McKinsey & Company\Documents\Alteryx - training from website\Challenge 243 Odd Man Out\challenge_243_start_file\Input.xlsx|||`CAD01$`
False
1
ReadList
Sheet Names
FileName
Simple
Contains
Sheet Names
True
fixed
2021-11-30 22:04:21
0
CAD01
2021-11-30 22:04:21
2021-11-30 22:04:21
Contains([Sheet Names],"CAD01")
WhichPopulation = IF EndsWith([FileName], "CAD01") THEN "Total"
ELSEIF EndsWith(...
Simple
IsNull
F2
True
fixed
2021-11-30 22:14:57
0
2021-11-30 22:14:57
2021-11-30 22:14:57
IsNull([F2])
FirstRow
Warn
[1950] = 1950
OR
[Países / Country]="América Latina"
Custom
[1950] = 1950
OR
[Países / Country]="América Latina"
Warn
[Men]>[Women]
AND
tonumber([Year])<2020
Custom
[Men]>[Women]
AND
tonumber([Year])<2020
Year - Descending
First
1
First 1
PercentageOfMen - Ascending
First
1
First 1
[Year]="2100"
AND
Men>[Women]
Custom
[Year]="2100"
AND
Men>[Women]
Warning
All
ByName
Question - Ascending
Países / Country - Ascending
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
challenge_243_EHB_completed