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













0















enter image description here



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) ?










share|improve this question









New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 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
















0















enter image description here



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) ?










share|improve this question









New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 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














0












0








0


1






enter image description here



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) ?










share|improve this question









New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












enter image description here



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






share|improve this question









New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 4 mins ago









PolyGeo

53.5k1780240




53.5k1780240






New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 5 hours ago









FelixFelix

142




142




New contributor




Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Felix is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 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





    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










1 Answer
1






active

oldest

votes


















0














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"





share|improve this answer

























    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.










    draft saved

    draft discarded


















    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









    0














    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"





    share|improve this answer






























      0














      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"





      share|improve this answer




























        0












        0








        0







        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"





        share|improve this answer















        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"






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 6 mins ago









        PolyGeo

        53.5k1780240




        53.5k1780240










        answered 3 hours ago









        TeddyTedTedTeddyTedTed

        69319




        69319






















            Felix is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Щит и меч (фильм) Содержание Названия серий | Сюжет |...

            is 'sed' thread safeWhat should someone know about using Python scripts in the shell?Nexenta bash script uses...

            Meter-Bus Содержание Параметры шины | Стандартизация |...