[Qgis-user] How to create one new string-value from many other string-values?

[Aron Gergely]

By accident I did not reply via the list :( see my suggested solution below

On 23/09/2020 10:10, Aron Gergely wrote:
> Hi Jan,
>
> You would be able to solve this with the 'Aggregate' tool:
> https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#qgisaggregate
>
> It groups rows of data according to an expression (just per ID value 
> in your case)
> and can  aggregate the attribute field values via aggregate functions.
> For your field containing all those street name letters, you could 
> then select the 'concatenate' function.
>
> You may have to look into sorting your rows if the letters are not 
> concatenated in the right order.
> The tool also supports expressions on the input fields.
>
> Good luck!
>
> Aron
>
> On 23/09/2020 09:04, Jan.Rutha at STADT-KOELN.DE 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.
>>
>> ------------------------------------------------------------------------
>> Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem 
>> Newsletter! Newsletter Anmeldung 
>> <https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein>
>>
>> ------------------------------------------------------------------------
>> <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
>> 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
>
> -- 
> 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200923/76b4ae5f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: aron_gergely.vcf
Type: text/x-vcard
Size: 4 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200923/76b4ae5f/attachment.vcf>