Filtering attribute table based on names in another table using QGIS? The 2019 Stack Overflow Developer Survey Results Are InUpdate postgres/postgis point data attribute from another enclosed polygon shapefile in QGISTechniques for Filtering the Attribute Table in QGIS's Print ComposerSelection subquery using another table in database ArcGISWhat does an asterisk (*) mean when shown beside a field name in the attribute table?Filtering information in two attribute tables using QGIS?How to create a unique identifier in the attribute table based on spatial location within another layer?How to filter in the attribute table within an attribute name?How to change the Fieldname(s) in the attribute tableDeleting a common word in attribute tableGeometry based automatic fill of fields in attribute table
I am an eight letter word. What am I?
How to support a colleague who finds meetings extremely tiring?
What do hard-Brexiteers want with respect to the Irish border?
Mathematics of imaging the black hole
Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?
Is bread bad for ducks?
Sums of normal random variables
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
What do I do when my TA workload is more than expected?
Why can't devices on different VLANs, but on the same subnet, communicate?
Are there any other methods to apply to solving simultaneous equations?
Worn-tile Scrabble
Are spiders unable to hurt humans, especially very small spiders?
Falsification in Math vs Science
Pokemon Turn Based battle (Python)
Straighten subgroup lattice
How to type a long/em dash `—`
Why doesn't mkfifo with a mode of 1755 grant read permissions and sticky bit to the user?
Old scifi movie from the 50s or 60s with men in solid red uniforms who interrogate a spy from the past
writing variables above the numbers in tikz picture
Button changing its text & action. Good or terrible?
How safe is it to go to Baghdad?
Can withdrawing asylum be illegal?
Why are there uneven bright areas in this photo of black hole?
Filtering attribute table based on names in another table using QGIS?
The 2019 Stack Overflow Developer Survey Results Are InUpdate postgres/postgis point data attribute from another enclosed polygon shapefile in QGISTechniques for Filtering the Attribute Table in QGIS's Print ComposerSelection subquery using another table in database ArcGISWhat does an asterisk (*) mean when shown beside a field name in the attribute table?Filtering information in two attribute tables using QGIS?How to create a unique identifier in the attribute table based on spatial location within another layer?How to filter in the attribute table within an attribute name?How to change the Fieldname(s) in the attribute tableDeleting a common word in attribute tableGeometry based automatic fill of fields in attribute table
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a shapefile showing a list of district names. I have (currently in Excel) a long list of district names in a table. I would like to filter those districts that are in the other list. I think this is something to do with the attribute table and an expression, but I don;t know the expression for "this name is another another list".
qgis attribute-table select-by-attribute
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
add a comment |
I have a shapefile showing a list of district names. I have (currently in Excel) a long list of district names in a table. I would like to filter those districts that are in the other list. I think this is something to do with the attribute table and an expression, but I don;t know the expression for "this name is another another list".
qgis attribute-table select-by-attribute
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
Which list are you referring when you saidthe other list? Is it the one in the excel file or the shapefile?
– ahmadhanb
Mar 6 at 11:57
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28
add a comment |
I have a shapefile showing a list of district names. I have (currently in Excel) a long list of district names in a table. I would like to filter those districts that are in the other list. I think this is something to do with the attribute table and an expression, but I don;t know the expression for "this name is another another list".
qgis attribute-table select-by-attribute
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
I have a shapefile showing a list of district names. I have (currently in Excel) a long list of district names in a table. I would like to filter those districts that are in the other list. I think this is something to do with the attribute table and an expression, but I don;t know the expression for "this name is another another list".
qgis attribute-table select-by-attribute
qgis attribute-table select-by-attribute
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
edited Mar 6 at 22:44
PolyGeo♦
53.9k1782246
53.9k1782246
asked Mar 6 at 11:36
user1778351user1778351
311
asked Mar 6 at 11:36
user1778351user1778351
311
asked Mar 6 at 11:36
user1778351user1778351
311
311
Which list are you referring when you saidthe other list? Is it the one in the excel file or the shapefile?
– ahmadhanb
Mar 6 at 11:57
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28
add a comment |
Which list are you referring when you saidthe other list? Is it the one in the excel file or the shapefile?
– ahmadhanb
Mar 6 at 11:57
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28
Which list are you referring when you said
the other list? Is it the one in the excel file or the shapefile?– ahmadhanb
Mar 6 at 11:57
Which list are you referring when you said
the other list? Is it the one in the excel file or the shapefile?– ahmadhanb
Mar 6 at 11:57
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28
add a comment |
1 Answer
1
active
oldest
votes
Try using the 'Join attribute by field value' processing tool
Assuming that both tables have a field in common. I.e. link the two together on district code and then filter your data once joined.
answered Mar 6 at 14:02
Dave CDave C
848
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314550%2ffiltering-attribute-table-based-on-names-in-another-table-using-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try using the 'Join attribute by field value' processing tool
Assuming that both tables have a field in common. I.e. link the two together on district code and then filter your data once joined.
answered Mar 6 at 14:02
Dave CDave C
848
add a comment |
Try using the 'Join attribute by field value' processing tool
Assuming that both tables have a field in common. I.e. link the two together on district code and then filter your data once joined.
answered Mar 6 at 14:02
Dave CDave C
848
add a comment |
Try using the 'Join attribute by field value' processing tool
Assuming that both tables have a field in common. I.e. link the two together on district code and then filter your data once joined.
answered Mar 6 at 14:02
Dave CDave C
848
Try using the 'Join attribute by field value' processing tool
Assuming that both tables have a field in common. I.e. link the two together on district code and then filter your data once joined.
answered Mar 6 at 14:02
Dave CDave C
848
answered Mar 6 at 14:02
Dave CDave C
848
answered Mar 6 at 14:02
Dave CDave C
848
answered Mar 6 at 14:02
Dave CDave C
848
848
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f314550%2ffiltering-attribute-table-based-on-names-in-another-table-using-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which list are you referring when you said
the other list? Is it the one in the excel file or the shapefile?– ahmadhanb
Mar 6 at 11:57
It would the list that is in the excel file. So I would like to highlight those districts in the shapefile that match entries in a separate list of districts in an excel file
– user1778351
Mar 6 at 12:28