La carte Excel peut-elle être filtrée si la carte web a un filtre défini ?

Question

Première utilisation de ce produit.<\/P> Après avoir géocodé les adresses dans une feuille de calcul, j'ai partagé la carte sur mon compte. Je n'ai pas trouvé d'outil de filtre dans Layers, alors j'ai ajouté le filtre dans Map Viewer. Cependant, il ne semble pas qu'il s'affiche dans la carte Excel. J'ai essayé de recharger la carte mais cela n'a pas fonctionné. Est-ce possible ?<\/P>

ShannonCardoza · Answer

Hello @MikeOnzay! I have tested a few workflows here based on the suggested workflow from your comment. Here are my findings -

Workflow 1: If I select features I have 2 options: Filter sheet or Export.

Workflow 2: If I filter a spreadsheet (hide a row/column or delete/add) without refreshing my web page/map the pop-ups and features on the map will NOT update (sync automatically). Once I refresh I see the corrected map. Pop-ups included.

Workflow 3: If I add my data to the map, and make any edits (hide row/column or delete/add) this will not automatically sync but if I re-add my data all is well again. Pop-ups included.

All 3 workflows are what is expected. I suppose this can 'feel' a bit broken but refreshing the web page/map to refresh whatever it is you are looking at is quite the typical workflow. Anyhoo, let me know if I missed something or if you have any other questions on this!

Again thanks for your feedback!

-SC

MikeOnzay · Answer

I understand that there isn't a Create Filter option in the ArcGIS for Excel map. I did discover that it is possible to select features on the map and it will filter the spreadsheet. I was going to say that it's not possible to filter the spreadsheet and have it filter the map, however, when I filter on a column in Excel, while the same number of points are showing on the map, the popup values don't correspond with the filtered Excel rows. A new issue to troubleshoot.

ShannonCardoza · Answer

Good morning @MikeOnzay! Thank you for your question. Can you help clarify what exactly your workflow is? When you refer to filter, do you mean 'apply filter' or 'create a filter' expression? See Apply filters for more.

In ArcGIS for Excel, you can filter/sort when searching for content/feature layers to add to the map. So to answer your question, we do not currently have a tool for 'create filter' expressions as seen in Map Viewer but there may be a workflow using Excel filtering and our ArcGIS for Excel add-in that may work. I will wait for your reply for understand more!

-SC