<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
By accident I did not reply via the list :( see my suggested
solution below<br>
<br>
<div class="moz-cite-prefix">On 23/09/2020 10:10, Aron Gergely
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:43035d8e-09aa-1e61-f0e6-3eb3573e6668@rasterra.nl">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
Hi Jan,<br>
<br>
You would be able to solve this with the 'Aggregate' tool:<br>
<a class="moz-txt-link-freetext"
href="https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#qgisaggregate"
moz-do-not-send="true">https://docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/vectorgeometry.html#qgisaggregate</a><br>
<br>
It groups rows of data according to an expression (just per ID
value in your case)<br>
and can aggregate the attribute field values via aggregate
functions. <br>
For your field containing all those street name letters, you could
then select the 'concatenate' function.<br>
<br>
You may have to look into sorting your rows if the letters are not
concatenated in the right order.<br>
The tool also supports expressions on the input fields.<br>
<br>
Good luck!<br>
<br>
Aron<br>
<br>
<div class="moz-cite-prefix">On 23/09/2020 09:04, <a
class="moz-txt-link-abbreviated"
href="mailto:Jan.Rutha@STADT-KOELN.DE" moz-do-not-send="true">Jan.Rutha@STADT-KOELN.DE</a>
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5997a14236c34e72b7948c748e7adfa0@STADT-KOELN.DE">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB">hi there, <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I got a table with a
content for streetnames. For example the street
“Mainstreet” ist separated in <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">10 different rows of
data (one dataset for each letter in the word
“Mainstreet”). <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif;mso-fareast-language:DE"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB">I
would like to merge these 10 datasets to one dataset. All
those datasets have one ID – so they qgis should<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB">be
able to search for the same Id and create a new textstring
with all the leters. <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB">I
don’t know how to practicly implement my idea in QGIS.
Does anyone have an idea for me?<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB">Thanks
a lot and I wish you all a good day!<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB">Jan
R. <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:black;mso-fareast-language:DE" lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
</div>
<hr> <font face="Arial">Monatlich aktuelle Informationen Ihrer
Stadtverwaltung in unserem Newsletter! <a
href="https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein"
moz-do-not-send="true"> Newsletter Anmeldung</a><br>
<br>
</font>
<hr> <font face="Arial"><a
href="https://www.bundesregierung.de/breg-de/themen/corona-warn-app"
moz-do-not-send="true"><img
src="https://styleguide.bundesregierung.de/resource/blob/72496/1760346/6d7f611945ca42908c50804510c5335b/breg-vorschaubild-01-unterstuetzt-842x595px-jpg-srgb-v01-data.png"
moz-do-not-send="true" width="400"></a> </font>
<table>
<tbody>
<tr>
<td><a href="http://www.wahlhelfer.koeln/"
moz-do-not-send="true"><img
src="https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg"
alt="https://www.stadt-koeln.de/images/footer_wahlhelferaufruf2020.jpg"
moz-do-not-send="true"></a></td>
</tr>
<tr>
<td><br>
</td>
</tr>
</tbody>
</table>
<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" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" moz-do-not-send="true">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" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title>Email Signature</title>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Kind Regards,<br>
<br>
Aron Gergely<br>
+31 (0) 6 38 70 97 66<br>
<br>
<b>Rasterra</b> | <a href="https://www.rasterra.nl"
moz-do-not-send="true">www.rasterra.nl</a><a
moz-do-not-send="true"><br>
</a></div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title>Email Signature</title>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Kind Regards,<br>
<br>
Aron Gergely<br>
+31 (0) 6 38 70 97 66<br>
<br>
<b>Rasterra</b> | <a href="https://www.rasterra.nl">www.rasterra.nl</a><a><br>
</a></div>
</body>
</html>