function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mireille BonapartMireille Bonapart 

Wave/Einstein analytics reformat GeoJSON file

Hi,

I'm trying to reformat the GeoJSON file in the Create a Custom Map for Analytics Charts module (the Build and Administer Analytics trail). I'm having a hard time completing the following steps: 
  • For the Los Angeles zip codes, create a script or use a fancy regular-expressions formula to move external_id up one level so it’s a child of features.
  • Be sure to rename the new key-value node "id".
  • The value of each "id" will be a zip code, to match the zip codes in your dataset's Zipcode column.
  • If your script output a file with a new name, note the name of the file and its location. You need them when you upload the GeoJSON to Analytics.

I've opened the file in Sublime, but I'm not sure how to proceed. I did manage to move the external_id one level (only in the for the 90001 id). Don't think it would be efficient to move the other id's up manually? 

Anybody succeeded with this and perhaps explain to me how it is done?

Thanks! :)
Yoanna DimitrovaYoanna Dimitrova
Hi Mireille,
I am stuck at the same module. Did you learn how to modify the JSON file? 
Can you explain it to me please?
Thanks in advance!