Data formatting tutorial for visualizations in Carto DB from split string into string array Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: Reconciling location names with geographical coordinates n(Tommaso Elli - DensityDesign Research Lab - http://www.densitydesign.org/)nnIn order to complete this task, you need to apply a Spreadsheet Vertical Search function:nn=VLOOKUP(lookup_value; table_array; index_num; range_lookup)nnIf the name has this shape, then everything is working properly:nnAarau , Aargau, SwitzerlandnnIn most of the cases, names incorporate alternatives, but written in slightly different way. This is the reason why t
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)