On 23/09/2020 13:33, Aron Gergely wrote:
Hi Bernd,Try blogs? A web search on 'QGIS aggregate functions' used to yield me some nice blog resources.For example from Ujaval Gandhi: https://spatialthoughts.com/2019/04/12/summary-aggregation-qgis/ https://spatialthoughts.com/2019/04/19/advanced-aggregate-expressions/Not meaning to single him out of course, some other qgis contributors also share great resources! ;)Best regards, Aron On 23/09/2020 13:08, Bernd Vogelgesang wrote:On 23.09.20 10:21, Bernd Vogelgesang wrote:On 23.09.20 09:04, [email protected] wrote:hi there, I got a table with a content for streetnames. For example the street "Mainstreet" ist separated in 10 different rows of data (one dataset for each letter in the word "Mainstreet"). I would like to merge these 10 datasets to one dataset. All those datasets have one ID - so they qgis should be able to search for the same Id and create a new textstring with all the leters. I don't know how to practicly implement my idea in QGIS. Does anyone have an idea for me? Thanks a lot and I wish you all a good day! Jan R.I think you could try to use an aggregate expression in the field calculator for a new field. sth like: aggregate( layer:= 'streets', aggregate:='concatenate', expression:=name, concatenator:='', <- 2 single quotes, not 1 double, for an empty concatenator! filter:= ID ) I don't know if the filter for ID works in this way. Can't check that cause I do not own such "interesting" data ;) Cheers, Berndfound no way to make my initial aproach work, but this: array_to_string(array_agg("street",group_by:="ID"),'','') in the field calculator for a new text field glues together the complete street name If someone knows a resource with more examples how to work with all these great functions available, please post it.________________________________ Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! NewsletterAnmeldung<https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein>________________________________[https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png]<https://www.bundesregierung.de/breg-de/themen/corona-warn-app>[https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg]<http://www.wahlhelfer.koeln/>_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user-- Email Signature Kind Regards, Aron Gergely +31 (0) 6 38 70 97 66 *Rasterra* | www.rasterra.nl <https://www.rasterra.nl>
-- Email Signature Kind Regards, Aron Gergely +31 (0) 6 38 70 97 66 *Rasterra* | www.rasterra.nl <https://www.rasterra.nl>
<<attachment: aron_gergely.vcf>>
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
