<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 23.09.20 09:04,
<a class="moz-txt-link-abbreviated" href="mailto:Jan.Rutha@STADT-KOELN.DE">Jan.Rutha@STADT-KOELN.DE</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5997a14236c34e72b7948c748e7adfa0@STADT-KOELN.DE">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<p>I think you could try to use an aggregate expression in the field
calculator for a new field.</p>
<p>sth like:<br>
</p>
<p>aggregate(<br>
layer:= 'streets',<br>
aggregate:='concatenate',<br>
expression:=name,<br>
concatenator:='', <- 2 single quotes, not 1 double, for an
empty concatenator!<br>
filter:= ID<br>
)</p>
<p>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 ;)</p>
<p>Cheers,</p>
<p>Bernd<br>
</p>
<blockquote type="cite"
cite="mid:5997a14236c34e72b7948c748e7adfa0@STADT-KOELN.DE">
<pre class="moz-quote-pre" wrap="">
________________________________
Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! Newsletter Anmeldung<a class="moz-txt-link-rfc2396E" href="https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein"><https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein></a>
________________________________
[<a class="moz-txt-link-freetext" href="https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png">https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png</a>]<a class="moz-txt-link-rfc2396E" href="https://www.bundesregierung.de/breg-de/themen/corona-warn-app"><https://www.bundesregierung.de/breg-de/themen/corona-warn-app></a>
[<a class="moz-txt-link-freetext" href="https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg">https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg</a>]<a class="moz-txt-link-rfc2396E" href="http://www.wahlhelfer.koeln/"><http://www.wahlhelfer.koeln/></a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</body>
</html>