https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428094#M96324 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mehdibenayed_0-1709798315926.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161493iBE5EFE02F344E6B2/image-size/medium?v=v2&amp;px=400" role="button" title="mehdibenayed_0-1709798315926.png" alt="mehdibenayed_0-1709798315926.png" /></span></P> <P>i want to transform it like that :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mehdibenayed_1-1709798630371.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161494i0588B844652ADAB3/image-size/medium?v=v2&amp;px=400" role="button" title="mehdibenayed_1-1709798630371.png" alt="mehdibenayed_1-1709798630371.png" /></span></P> <P>what can i do ?</P> Fri, 15 Nov 2024 21:02:19 GMT mehdibenayed 2024-11-15T21:02:19Z https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428094#M96324 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mehdibenayed_0-1709798315926.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161493iBE5EFE02F344E6B2/image-size/medium?v=v2&amp;px=400" role="button" title="mehdibenayed_0-1709798315926.png" alt="mehdibenayed_0-1709798315926.png" /></span></P> <P>i want to transform it like that :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mehdibenayed_1-1709798630371.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161494i0588B844652ADAB3/image-size/medium?v=v2&amp;px=400" role="button" title="mehdibenayed_1-1709798630371.png" alt="mehdibenayed_1-1709798630371.png" /></span></P> <P>what can i do ?</P> Fri, 15 Nov 2024 21:02:19 GMT https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428094#M96324 mehdibenayed 2024-11-15T21:02:19Z https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428118#M96330 <P>What does the data look like in the source(s)?</P> <P>Is it a table like the first image, or are it multiple files?</P> Thu, 07 Mar 2024 08:31:38 GMT https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428118#M96330 LRuCelver 2024-03-07T08:31:38Z https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428119#M96331 <P>there are multiple files&nbsp;</P> Thu, 07 Mar 2024 08:33:10 GMT https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428119#M96331 mehdibenayed 2024-03-07T08:33:10Z https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428162#M96337 <P>Can you share samples/examples for the structure of the files so we can try to contruct the data structure you want?</P> <P>It looks like the files have been concatenated when they should have been joined using common key fields.</P> Thu, 07 Mar 2024 09:53:20 GMT https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428162#M96337 LRuCelver 2024-03-07T09:53:20Z https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428372#M96358 <P>I agree with&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/285770">@LRuCelver</a>&nbsp;. Can you try joining the files</P> Thu, 07 Mar 2024 16:37:53 GMT https://community.qlik.com/t5/App-Development/grouping-data-to-remove-null-values/m-p/2428372#M96358 dataexplorer 2024-03-07T16:37:53Z