topic Re: Creating a table with unique column records in Talend Studio https://community.qlik.com/t5/Talend-Studio/Creating-a-table-with-unique-column-records/m-p/2271643#M49175 <P>Hi,</P> <P>Use tDenormalize for that.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lufk.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128512iAD720E7E52877C5E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lufk.png" alt="0683p000009Lufk.png" /></span></SPAN></P> Mon, 12 Jun 2017 15:03:41 GMT TRF 2017-06-12T15:03:41Z Creating a table with unique column records https://community.qlik.com/t5/Talend-Studio/Creating-a-table-with-unique-column-records/m-p/2271642#M49174 <P>I have a table like the one above, I would like to get like the one below. Can I do that in Talend, which component should I use?</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled3.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LugX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130882i7B0DE52A81C97D71/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LugX.png" alt="0683p000009LugX.png" /></span></SPAN></P> Mon, 12 Jun 2017 14:38:18 GMT https://community.qlik.com/t5/Talend-Studio/Creating-a-table-with-unique-column-records/m-p/2271642#M49174 Anonymous 2017-06-12T14:38:18Z Re: Creating a table with unique column records https://community.qlik.com/t5/Talend-Studio/Creating-a-table-with-unique-column-records/m-p/2271643#M49175 <P>Hi,</P> <P>Use tDenormalize for that.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lufk.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128512iAD720E7E52877C5E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lufk.png" alt="0683p000009Lufk.png" /></span></SPAN></P> Mon, 12 Jun 2017 15:03:41 GMT https://community.qlik.com/t5/Talend-Studio/Creating-a-table-with-unique-column-records/m-p/2271643#M49175 TRF 2017-06-12T15:03:41Z