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

[Bernd Vogelgesang]

On 23.09.20 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.
>
>
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,

Bernd

>
>
> ________________________________
>
> Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! Newsletter Anmeldung<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
> 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/20200923/6c69f666/attachment.html>