Kann die Excel-Karte gefiltert werden, wenn die Webkarte einen Filter gesetzt hat?

Question

Erstes Mal, dass ich dieses Produkt benutze.<\/P> Nachdem ich die Adressen in einer Tabelle geokodiert habe, habe ich die Karte mit meinem Konto geteilt. Ich habe kein Filterwerkzeug in den Layers gefunden, also habe ich den Filter im Map Viewer hinzugefügt. Es scheint jedoch nicht so, als würde dieser in der Excel-Karte angezeigt. Ich habe versucht, die Karte neu zu laden, aber das hat nicht funktioniert. Ist das möglich?<\/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