[Qgis-user] Easy way to use categorical classification on 'array' type fields?

[Richard Duivenvoorde]

Greg, Thanks!
The data sets come from REST-API services, and are updated in realtime so going through PG would be a plan B, I think
Richard

On 06-03-2025 13:47, Greg Troxel via QGIS-User wrote:
> Richard Duivenvoorde via QGIS-User <qgis-user at lists.osgeo.org> writes:
> 
>> We have vector data with one field in that data which is an "n array of (freeform) tags"...
>>
>> So having 10 records, we may have 30 different tags.
>>
>> Is there a way to 'explode' those records within QGIS (without manipulating the source), so we could create a 'classification' of all individual tags...
>> My idea would be to see a record with 3 tags then 3x in QGIS, but being able to only check ONE of the tags, my user could view the data base on individual tags...
> 
> If you're willing to store this in postgresql/postgis, you can probably
> create a view to do this reasonably easily.  Then you aren't changing
> the source, or needing to synchronize, but you can still have a single
> tag column and multiple rows.
> 
> postgresql also has hstore, but I don't think that's what you want:
> 
>    https://www.postgresql.org/docs/current/hstore.html
> 
> _______________________________________________
> 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