topic Concat Trick in QlikView https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436431#M817169 <HTML><HEAD></HEAD><BODY><P>Hi Experts - I have attached the qvw file with data loaded.. have four columns in that.. I need to concat those and wanted see like below screen shot in qlikview.. 1st 3 columns concatenating should not be an issue.. 3rd and 4th while merging.. i need the spaces to start from the equal axis.. Any idea?</P><P></P><P><IMG __jive_id="175571" alt="Concat.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175571_Concat.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bharani8 2020-11-25T16:16:04Z Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436431#M817169 <HTML><HEAD></HEAD><BODY><P>Hi Experts - I have attached the qvw file with data loaded.. have four columns in that.. I need to concat those and wanted see like below screen shot in qlikview.. 1st 3 columns concatenating should not be an issue.. 3rd and 4th while merging.. i need the spaces to start from the equal axis.. Any idea?</P><P></P><P><IMG __jive_id="175571" alt="Concat.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175571_Concat.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436431#M817169 bharani8 2020-11-25T16:16:04Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436432#M817170 <HTML><HEAD></HEAD><BODY><P>not clear to me, what the desired outcome should be?</P></BODY></HTML> Tue, 05 Sep 2017 07:30:17 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436432#M817170 prieper 2017-09-05T07:30:17Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436433#M817171 <HTML><HEAD></HEAD><BODY><P>Plz chk the screen shot i showed .. i need to see like that..</P></BODY></HTML> Tue, 05 Sep 2017 08:14:25 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436433#M817171 bharani8 2017-09-05T08:14:25Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436434#M817172 <HTML><HEAD></HEAD><BODY><P>Hi Bharani,</P><P>The data you have uploaded is the same as your screenshot which was what you said you wanted to achieve.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Col</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Colum</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Column</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Co</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12WS</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TG</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">67YH</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SDFD45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45FB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TYUP</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASF</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FV</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">56HJ</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RTED567R4567</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">GB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">78JK</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ERTDFVY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASFSG567</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">HN</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">98KL</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4565YTRE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASCDV678</SPAN></TD></TR></TBODY></TABLE><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Tue, 05 Sep 2017 09:55:34 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436434#M817172 effinty2112 2017-09-05T09:55:34Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436435#M817173 <HTML><HEAD></HEAD><BODY><P>I have uploaded the screen shot from excel... i am trying to replicate the same in qv.. but i cannot.. So looking for some help here <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 05 Sep 2017 10:00:13 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436435#M817173 bharani8 2017-09-05T10:00:13Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436436#M817174 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>The table I pasted was <EM>from</EM> your qvw</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Col</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Colum</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Column</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Co</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12WS</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TG</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">67YH</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SDFD45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45FB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TYUP</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASF</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FV</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">56HJ</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RTED567R4567</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">GB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">78JK</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ERTDFVY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASFSG567</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">HN</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">98KL</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4565YTRE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASCDV678</SPAN></TD></TR></TBODY></TABLE><P></P><P>= screenshot of your desired result</P><P></P><P><IMG alt="Concat.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175588_Concat.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 05 Sep 2017 10:04:01 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436436#M817174 effinty2112 2017-09-05T10:04:01Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436437#M817175 <HTML><HEAD></HEAD><BODY><P>Haha.. I need the concatenated&nbsp; one in qv</P></BODY></HTML> Tue, 05 Sep 2017 10:09:21 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436437#M817175 bharani8 2017-09-05T10:09:21Z Re: Concat Trick https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436438#M817176 <HTML><HEAD></HEAD><BODY><P>hello bharani,</P><P></P><P>Do you expect output like below?</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Col</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Colum</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Column</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Co</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>COL</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45RF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R2343RFTY</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12WS</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2345R</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY34562345R</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">HN</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">98KL</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4565YTRE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASCDV678</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4565YTREASCDV678</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DC</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">45FB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TYUP</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASF</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TYUPASF</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">GB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">78JK</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ERTDFVY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ASFSG567</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ERTDFVYASFSG567</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12DE</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FREIHJY3456</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45FREIHJY3456</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">TG</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">67YH</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTY</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SDFD45</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2343RFTYSDFD45</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">FV</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">56HJ</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RTED567R4567</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WERD45</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">RTED567R4567WERD45</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 05 Sep 2017 11:43:22 GMT https://community.qlik.com/t5/QlikView/Concat-Trick/m-p/1436438#M817176 rohitraut 2017-09-05T11:43:22Z