Re: [Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread Guillermo Parra via QGIS-User
Thank you very much Osin! With the example that you kindly provided is more clear. I will try it and again, thank you very much! Regards. El martes, 14 de mayo de 2024, 13:52:16 GMT-6, oisin.kelly.w...@gmail.com escribió: get_feature(layer, attribute, value) This returns a feature. Y

Re: [Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread oisin.kelly.wild--- via QGIS-User
get_feature(layer, attribute, value) This returns a feature. You can then wrap this in attributes() to return a dictionary of attribute names and  values. You then add ['attributename'] on end to return value. So for each table something like attributes(get_feature('table1', 'common-id-name',

Re: [Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread oisin.kelly.wild--- via QGIS-User
No it won't work. It's not SQL syntax, it's expression syntax. So you need to use a function to get the corresponding feature from another layer. Hence getfeature() or one of the  overlay_ functions. You will end up with a long expression. Or, you could use sql in dB manager? ⁣Oisin 07570 9774

Re: [Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread Guillermo Parra via QGIS-User
Hello Oisin, Thank you for your guidance regarding this topic, and I am sorry if I need further assistance, but I'm kind of new to QGIS. Regarding the need to define the layer for each attribute, will it work if I stated like I had wroten before? i.e.:'Table1.H3centr_h9_cobcubierto'  = 1 OR  'Tab

Re: [Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread oisin.kelly.wild--- via QGIS-User
You definitely need to define the layer for each attribute (except the current layer). You also need a way to find the comparable record, e.g. (i) with a common id (use getfeature() to access attribute) or (ii) spatially use one of the overlay functions. Oisin Get BlueMail for Android ​ On 14

[Qgis-user] Can't accomplish comparisions between different Map Layer Table's

2024-05-14 Thread Guillermo Parra via QGIS-User
Hi, I have several tables with the same fields, same grid information, but different field data for each one (information from different providers, let's say). Particularly, I have a field with 0 and 1 which represent if each provider have, or not have coverage in that area. I want to compare th