Comparing string value in attribute table?QGIS attribution and geometry queryEditing values in attribute...
Can I combine Divination spells with Arcane Eye?
Can I legally make a website about boycotting a certain company?
Now...where was I?
Why write a book when there's a movie in my head?
What's the function of the word "ли" in the following contexts?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
What does @ mean in a hostname in DNS configuration?
Are there any rules for handling distractions whilst performing skill checks?
What does an unprocessed RAW file look like?
What's the meaning of #0?
If I have Haste cast on me, does it reduce the casting time for my spells that normally take more than a turn to cast?
How does holding onto an active but un-used credit card affect your ability to get a loan?
Taking an academic pseudonym?
How can I make my enemies feel real and make combat more engaging?
Have any astronauts or cosmonauts died in space?
Identical projects by students at two different colleges: still plagiarism?
Why and/or operations in python statement are behaving unexpectedly?
Can a Hydra make multiple opportunity attacks at once?
What happens if both players misunderstand the game state until it's too late?
Exploding Numbers
Why is quixotic not Quixotic (a proper adjective)?
Minimum energy path of a potential energy surface
Why is Shelob considered evil?
Do the speed limit reductions due to pollution also apply to electric cars in France?
Comparing string value in attribute table?
QGIS attribution and geometry queryEditing values in attribute table columnhaving a standard value when filling in attribute tableLabel only one polygon in canvas/map view per category/value in attribute tableAutomate attribute table changes in QGISLink in the attribute table to the attribute table of an object of another layerQGIS: Is there any interactive tool to select previous or next points using fid/attribute table order?NULL value not equal to empty value for attributeAttribute table in QGIS showing a subset of desired features after query builderString Comparison in Same Field
I am working on QGIS. It is a line feature.
Say we have three consecutive links. If the first and the last link has the same attribute value and the centre differs, I need to select those.
Is there any query for that in QGIS?
In the below picture, there are three consecutive links. Of that, I need to select the centre linke named "B", which differs from the other two. Can I have a query for comparing the attribution of the consecutive links and highlights the name which is odd (say "B" in this case) ?
qgis query
New contributor
add a comment |
I am working on QGIS. It is a line feature.
Say we have three consecutive links. If the first and the last link has the same attribute value and the centre differs, I need to select those.
Is there any query for that in QGIS?
In the below picture, there are three consecutive links. Of that, I need to select the centre linke named "B", which differs from the other two. Can I have a query for comparing the attribution of the consecutive links and highlights the name which is odd (say "B" in this case) ?
qgis query
New contributor
2
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
1
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
2
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago
add a comment |
I am working on QGIS. It is a line feature.
Say we have three consecutive links. If the first and the last link has the same attribute value and the centre differs, I need to select those.
Is there any query for that in QGIS?
In the below picture, there are three consecutive links. Of that, I need to select the centre linke named "B", which differs from the other two. Can I have a query for comparing the attribution of the consecutive links and highlights the name which is odd (say "B" in this case) ?
qgis query
New contributor
I am working on QGIS. It is a line feature.
Say we have three consecutive links. If the first and the last link has the same attribute value and the centre differs, I need to select those.
Is there any query for that in QGIS?
In the below picture, there are three consecutive links. Of that, I need to select the centre linke named "B", which differs from the other two. Can I have a query for comparing the attribution of the consecutive links and highlights the name which is odd (say "B" in this case) ?
qgis query
qgis query
New contributor
New contributor
edited 4 mins ago
PolyGeo♦
53.5k1780240
53.5k1780240
New contributor
asked 5 hours ago
FelixFelix
142
142
New contributor
New contributor
2
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
1
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
2
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago
add a comment |
2
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
1
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
2
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago
2
2
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
1
1
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
2
2
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Assuming that you have three fields in your attribute table (let's call them field1, field2, and field3 for this) and you want to select features where field1 and field3 are the same but field2 is different, then you can use this expression to select them:
"field1" = "field3" AND "field1" <> "field2"
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
});
}
});
Felix is a new contributor. Be nice, and check out our Code of Conduct.
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%2f313169%2fcomparing-string-value-in-attribute-table%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
Assuming that you have three fields in your attribute table (let's call them field1, field2, and field3 for this) and you want to select features where field1 and field3 are the same but field2 is different, then you can use this expression to select them:
"field1" = "field3" AND "field1" <> "field2"
add a comment |
Assuming that you have three fields in your attribute table (let's call them field1, field2, and field3 for this) and you want to select features where field1 and field3 are the same but field2 is different, then you can use this expression to select them:
"field1" = "field3" AND "field1" <> "field2"
add a comment |
Assuming that you have three fields in your attribute table (let's call them field1, field2, and field3 for this) and you want to select features where field1 and field3 are the same but field2 is different, then you can use this expression to select them:
"field1" = "field3" AND "field1" <> "field2"
Assuming that you have three fields in your attribute table (let's call them field1, field2, and field3 for this) and you want to select features where field1 and field3 are the same but field2 is different, then you can use this expression to select them:
"field1" = "field3" AND "field1" <> "field2"
edited 6 mins ago
PolyGeo♦
53.5k1780240
53.5k1780240
answered 3 hours ago
TeddyTedTedTeddyTedTed
69319
69319
add a comment |
add a comment |
Felix is a new contributor. Be nice, and check out our Code of Conduct.
Felix is a new contributor. Be nice, and check out our Code of Conduct.
Felix is a new contributor. Be nice, and check out our Code of Conduct.
Felix is a new contributor. Be nice, and check out our Code of Conduct.
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%2f313169%2fcomparing-string-value-in-attribute-table%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
2
Your question is a bit unclear. Could you add a screenshot showing the line(s) and the attribute table?
– BERA
4 hours ago
1
And explain a bit more the logic of the selection you aim ...
– snaileater
4 hours ago
2
Welcome to GIS.se! Please click 'edit' and update your question with a clear example of your data.
– Simbamangu
4 hours ago