topic Re: Merging Group Names into one single Group in QlikView https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408273#M490834 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi </SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can use concatenate statement</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">load Builds as&nbsp; IT-Support,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Business Developer aS Business Systems ,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk AS <STRONG>Service Desk,</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Technical Support&nbsp; <BR /></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">from test.xls</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">concatenate</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">load IT Support as&nbsp; IT-Support,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Financial Systems AS Business Systems </SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk Desktop AS <STRONG>Service Desk</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>FROM test XLS</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>CONCATENATE</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>LOAD </STRONG></SPAN><BR /><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk NHS AS </SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"> <STRONG>Service Desk</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"> from test.xls</SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom<BR /></SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 12 Oct 2012 10:42:32 GMT thomas_skariah 2012-10-12T10:42:32Z Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408268#M490829 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have extracted all the information from our call logging system and ran it into Qlikview, and in a field called <STRONG>suppgroup </STRONG>I have a list box with the following groups:</P><P></P><P><STRONG>Builds</STRONG></P><P><STRONG>Financial Systems</STRONG></P><P><STRONG>Business Developer</STRONG></P><P><STRONG>Service Desk</STRONG></P><P><STRONG>Service Desk Desktop</STRONG></P><P><STRONG>Service Desk NHS</STRONG></P><P><STRONG>Technical Support</STRONG></P><P><STRONG>IT Support</STRONG></P><P><STRONG>Helpdesk</STRONG></P><P></P><P>What I am looking to achieve is to put the above groups into a specific group.&nbsp; Please see example below.</P><P></P><P><STRONG>Builds, IT Support, Helpdesk = IT Support</STRONG></P><P><STRONG>Business Developer, Financial Systems = Business Systems</STRONG></P><P><STRONG>Service Desk, Service Desk Desktop, Service Desk NHS = Service Desk</STRONG></P><P><STRONG>Technical Support = Technical Support</STRONG></P><P></P><P>As you can see above, I should only have 4 groups called, <STRONG>IT Support</STRONG>, <STRONG>Business Systems</STRONG>, <STRONG>Service Desk</STRONG> and <STRONG>Technical Support</STRONG>.</P><P></P><P>Would someone be able to help me with this query please?</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Fri, 12 Oct 2012 10:20:35 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408268#M490829 2012-10-12T10:20:35Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408269#M490830 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Is this is the column names coming from a single table?</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Builds</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Financial Systems</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Business Developer</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Service Desk</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Service Desk Desktop</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Service Desk NHS</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Technical Support</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>IT Support</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>Helpdesk</STRONG></SPAN></P><P></P><P><STRONG style="font-family: calibri,verdana,arial,sans-serif;">Regards,</STRONG></P><P><STRONG><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN><BR /></STRONG></P><P></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Fri, 12 Oct 2012 10:23:31 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408269#M490830 thomas_skariah 2012-10-12T10:23:31Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408270#M490831 <HTML><HEAD></HEAD><BODY><P>Hi Tom,</P><P></P><P>Yes they are all coming from a table called <STRONG>opencall.</STRONG></P><P></P><P>Regards,</P><P></P><P>Jon</P></BODY></HTML> Fri, 12 Oct 2012 10:26:18 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408270#M490831 2012-10-12T10:26:18Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408271#M490832 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hope this what you are looking for.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Builds &amp;'-' &amp;IT Support &amp;'-'Helpdesk as IT-Support</SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Business Developer &amp;'-'&amp; Financial Systems as Business Systems</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk &amp;'-'&amp; Service Desk Desktop &amp;'-' &amp; Service Desk NHS as Business Systems</SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Technical Support&nbsp; </SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom</SPAN></P></BODY></HTML> Fri, 12 Oct 2012 10:28:50 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408271#M490832 thomas_skariah 2012-10-12T10:28:50Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408272#M490833 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Sorry i think this not what you looking for.</SPAN></P></BODY></HTML> Fri, 12 Oct 2012 10:31:21 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408272#M490833 thomas_skariah 2012-10-12T10:31:21Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408273#M490834 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi </SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">You can use concatenate statement</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">load Builds as&nbsp; IT-Support,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Business Developer aS Business Systems ,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk AS <STRONG>Service Desk,</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Technical Support&nbsp; <BR /></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">from test.xls</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">concatenate</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">load IT Support as&nbsp; IT-Support,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Financial Systems AS Business Systems </SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk Desktop AS <STRONG>Service Desk</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>FROM test XLS</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>CONCATENATE</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><STRONG>LOAD </STRONG></SPAN><BR /><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Service Desk NHS AS </SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"> <STRONG>Service Desk</STRONG></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"> from test.xls</SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Tom<BR /></SPAN></P><P></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P></BODY></HTML> Fri, 12 Oct 2012 10:42:32 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408273#M490834 thomas_skariah 2012-10-12T10:42:32Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408274#M490835 <HTML><HEAD></HEAD><BODY><P>Thanks all,&nbsp; Ill give them a try and let you know how I get on.</P></BODY></HTML> Fri, 12 Oct 2012 15:50:03 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408274#M490835 2012-10-12T15:50:03Z Re: Merging Group Names into one single Group https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408275#M490836 <HTML><HEAD></HEAD><BODY><P>Here's one option:</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">[Groups]:</SPAN><BR /><SPAN style="font-family: courier new,courier;">LOAD</SPAN><BR /><SPAN style="font-family: courier new,courier;"> group</SPAN><BR /><SPAN style="font-family: courier new,courier;">,trim(subfield(suppgroups,',')) as suppgroup</SPAN><BR /><SPAN style="font-family: courier new,courier;">INLINE [</SPAN><BR /><SPAN style="font-family: courier new,courier;">group: suppgroups</SPAN><BR /><SPAN style="font-family: courier new,courier;">IT Support: Builds, IT Support, Helpdesk</SPAN><BR /><SPAN style="font-family: courier new,courier;">Business Systems: Business Developer, Financial Systems</SPAN><BR /><SPAN style="font-family: courier new,courier;">Service Desk: Service Desk, Service Desk Desktop, Service Desk NHS</SPAN><BR /><SPAN style="font-family: courier new,courier;">Technical Support: Technical Support</SPAN><BR /><SPAN style="font-family: courier new,courier;">] (delimiter is ':');</SPAN></P></BODY></HTML> Fri, 12 Oct 2012 22:30:50 GMT https://community.qlik.com/t5/QlikView/Merging-Group-Names-into-one-single-Group/m-p/408275#M490836 johnw 2012-10-12T22:30:50Z