Custom geocoding in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load a custom geocoding CSV file in Tableau.

Tableau

LOAD DATA FROM '[1]' AS CustomGeo

Drag options to blanks, or click blank then click option'

Amap_data.csv

Bcustom_geocoding.csv

Clocations.csv

Ddefault_geocoding.csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using the default geocoding file name instead of the custom one.

Using unrelated CSV file names.

Tableau requires the custom geocoding file to be loaded from the correct CSV file, usually named custom_geocoding.csv.

2fill in blank

medium

Complete the calculation to create a custom latitude field using the data column.

Tableau

FLOAT([[1]])

Drag options to blanks, or click blank then click option'

ALatitude

BLongitude

CCity

DCountry

Attempts:

3 left

💡 Hint

Common Mistakes

Using Longitude instead of Latitude.

Using non-numeric columns like City or Country.

Latitude values are used to create the custom latitude field, so the column Latitude is correct.

3fill in blank

hard

Fix the error in the custom geocoding join calculation to match the location field.

Tableau

[Location] = '[1]'

Drag options to blanks, or click blank then click option'

ACity

B[City]

CLocation

D[Country]

Attempts:

3 left

💡 Hint

Common Mistakes

Using field references inside the string.

Using incorrect field names.

The join condition should compare the [Location] field to the string 'City' without brackets, so City is correct.

4fill in blank

hard

Fill both blanks to create a calculated field that converts longitude and latitude to numbers.

Tableau

FLOAT([[1]]) + FLOAT([[2]])

Drag options to blanks, or click blank then click option'

ALongitude

BLatitude

CCity

DCountry

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-numeric fields like City or Country.

Mixing up Latitude and Longitude.

Longitude and Latitude fields must be converted to float numbers for calculations.

5fill in blank

hard

Fill all three blanks to create a custom geocoding join condition matching city, state, and country.

Tableau

[CustomGeo].[City] = [Data].[[1]] AND [CustomGeo].[State] = [Data].[[2]] AND [CustomGeo].[[3]] = [Data].[Country]

Drag options to blanks, or click blank then click option'

ACity

BState

CCountry

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect field names like Region instead of Country.

Mixing up the order of fields.

The join condition must match City, State, and Country fields correctly between custom geocoding and data tables.