[Qgis-user] Symbology using an expression to find a field with known suffix

[Delaz J]

Hi Andrew,

Try something like

  eval(
   array_to_string(
    array_filter(
     map_akeys(attributes()),
     right(@element, 5) = '_blah')
   )
  )

You may want to read the help of each involved function to better 
understand how things work here.

HTH,

Harrissou

Le 21/07/2021 à 02:36, Andrew Hughes a écrit :
> Hi All,
>
> Any help would be much appreciated,  sorry for just throwing this out 
> there... QGIS is very new to me.
>
> I have lots of tables that I would like to apply common symbology and 
> best I explain with an example:
>
> table_a.foo_blah
> table_b.boo_blah
> table_c.whatever_blah
> table_d.i_cant_believe_its_not_butter_blah
>
> Q: What would the expression be to find the field ending with "_blah" 
> and use/return that fields value (as the symbology's categorical 
> value)? I will never know what the field is called, just that it 
> always ends in _blah.
>
> Big thanks in advance,
> Andrew
>
>
>
>
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210721/476b5052/attachment.html>