When following the data-wrangling-with-mongodb-data blog:
on Exploratory Version:22.214.171.124_WIN, using local instance of mongoDB containing Restaurant data
The address.coords column (containing 2-item list of long/ lat coordinates) disappears from table and summary view when running:
It’s still working fine for Mac, could be an Windows specific, we’ll look into it.
I tried this on Windows but it seems to be working on my end.
One thing I’m suspecting is if the
.drop=FALSE option is correctly set or not.
If you are generating unnest() command from the UI, you will need to select FALSE for “Drop other list columns”.
Could you double-check the above option?
Sorry it’s taken ages to get back to you.
I’ve tried to recreate the ‘problem’ (using v2.3 now) and I think I have confused the unnest() and mutate(=list_extract()) commands by wrongly doing
(Which rightly drops address.coord.)
Instead, I should have done the following two commands in turn
unnest(grades, .drop=False) mutate(longitude = list_extract(address.coord, position = 1))
Sorry for the mistake and thanks for looking at it nonetheless.
Hi Henry, thank you for the update.
Glad to hear it worked for you!