Timeline for Filter by attribute names from another layer in QGIS
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2020 at 17:04 | vote | accept | PeaceFrog | ||
| Feb 5, 2020 at 17:04 | comment | added | PeaceFrog | Thanks a lot! I think I had a couple of ideas with which I can bring order to the names and numbers | |
| Feb 3, 2020 at 21:45 | comment | added | Houska | Indeed, the answer was predicated on (original) assumption that the names in both layers would be identical. As in absolutely identical, coming from the same source, with same spelling, capitalization, punctuation, etc. You have 2 ways forward: you can figure out how to manipulate the names to create something same, with functions to adjust the capitalization, concatenate the number and name, etc. Or you can try with QGIS' fuzzy matching logic. But we're beginning to veer off into different questions/tutorials. Good luck! | |
| Feb 3, 2020 at 21:31 | comment | added | PeaceFrog | It's not working for me, I joined atribute, but all field is null. I think it's because names in two layers is not the same. I added that to the question. Layer one contains two attributes:road_numbe and road_name. Layer two contains only attribute Name, wich contains both number and name. So, for example, one road has 'Name: SR1 FERENTINO' on one layer and 'road_name: Ferentino', 'road_numbe: SS 1' on another | |
| Feb 2, 2020 at 20:55 | comment | added | Houska | You can actually use any field in Layer 2 that is different than the one you are joining by and that you know won’t be null in actual records in Layer 2 | |
| Feb 2, 2020 at 20:45 | comment | added | Houska | Layers will have some sort of field which is an (indexed) unique identifier: by convention usually called the FID, for Feature IDentifier. It may be called something else in your layers. In any case if you join Layer 2 to Layer 1, Layer2_FID in the join is a reliable tell that no matching feature was found in Layer 2. | |
| Feb 2, 2020 at 18:38 | comment | added | PeaceFrog | Thank you for answer but I do not quite understand it. What is FID? | |
| Jan 28, 2020 at 18:38 | history | answered | Houska | CC BY-SA 4.0 |