topic Re: Combine Columns & Rows - Business One OCQG & OCRD in QlikView https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904065#M1008507 <HTML><HEAD></HEAD><BODY><P>Adding the newsletter names as well:</P><P></P><P><STRONG>MapNames:</STRONG></P><P><STRONG>Mapping LOAD GroupCode,</STRONG></P><P><STRONG>&nbsp; GroupName</STRONG></P><P><STRONG>FROM OCQG;</STRONG></P><P></P><P>TempOCRD:</P><P>CrossTable(GroupCode,Newsletter)</P><P>LOAD * FROM ....;</P><P></P><P>OCRD:</P><P>Noconcatenate</P><P>LOAD CustomerCode,</P><P>&nbsp; keepchar(GroupCode, '0123456789') as GroupCode,</P><P>&nbsp; <STRONG>ApplyMap('MapNames', keepchar(GroupCode, '0123456789')) As GroupName,</STRONG></P><P>&nbsp; Newsletter</P><P>RESIDENT TempOCRD;</P><P></P><P>DROP TABLE TempORCD;</P></BODY></HTML> Fri, 08 May 2015 14:33:06 GMT jonathandienst 2015-05-08T14:33:06Z Combine Columns & Rows - Business One OCQG & OCRD https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904063#M1008505 <HTML><HEAD></HEAD><BODY><P>I'm not sure how this could be solved but I'm sure there is a way.</P><P></P><P>I have the following two tables:</P><P></P><P><STRONG>Table: OCQG </STRONG></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>GroupCode</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">GroupName</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Easter Newsletter</TD></TR><TR><TD>2</TD><TD>Christmas Newsletter</TD></TR><TR><TD>3</TD><TD>Summer Newsletter</TD></TR><TR><TD>4</TD><TD>Valentines Newsletter</TD></TR><TR><TD>5</TD><TD>Winter Newsletter</TD></TR><TR><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P><STRONG>Table: OCRD</STRONG></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>CustomerCode</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>...</STRONG></TH></TR><TR><TD>C10050</TD><TD>N</TD><TD>Y</TD><TD>N</TD><TD>N</TD><TD>Y</TD><TD>...</TD></TR><TR><TD>C10051</TD><TD>Y</TD><TD>Y</TD><TD>N</TD><TD>N</TD><TD>N</TD><TD>...</TD></TR><TR><TD>....</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I now want to know for each customer which newsletter they want and I imagine to get an end result of:</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="font-size: 13.3333330154419px;">CustomerCode</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>GroupCode</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>GroupName</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Newsletter</STRONG></TH></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">C10050</SPAN></TD><TD>1</TD><TD>Easter Newsletter</TD><TD>N</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">C10050</SPAN></TD><TD>2</TD><TD><SPAN style="font-size: 13.3333330154419px;">Christmas Newsletter</SPAN></TD><TD>Y</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">C10050</SPAN></TD><TD>3</TD><TD><SPAN style="font-size: 13.3333330154419px;">Summer Newsletter</SPAN></TD><TD>N</TD></TR><TR><TD>....</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>Is there a way to combine the rows and columns?</P><P></P><P>Thank you</P></BODY></HTML> Fri, 08 May 2015 14:14:37 GMT https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904063#M1008505 sprqlikview 2015-05-08T14:14:37Z Re: Combine Columns & Rows - Business One OCQG & OCRD https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904064#M1008506 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">TempOCRD:</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CrossTable(GroupCode,Newsletter)<BR /></SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD * FROM ....;</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">OCRD:</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Noconcatenate</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD CustomerCode,</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keepchar(GroupCode, '0123456789') as GroupCode,</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Newsletter</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RESIDENT TempOCRD;</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DROP TABLE TempORCD;<BR /></SPAN></P></BODY></HTML> Fri, 08 May 2015 14:20:05 GMT https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904064#M1008506 Gysbert_Wassenaar 2015-05-08T14:20:05Z Re: Combine Columns & Rows - Business One OCQG & OCRD https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904065#M1008507 <HTML><HEAD></HEAD><BODY><P>Adding the newsletter names as well:</P><P></P><P><STRONG>MapNames:</STRONG></P><P><STRONG>Mapping LOAD GroupCode,</STRONG></P><P><STRONG>&nbsp; GroupName</STRONG></P><P><STRONG>FROM OCQG;</STRONG></P><P></P><P>TempOCRD:</P><P>CrossTable(GroupCode,Newsletter)</P><P>LOAD * FROM ....;</P><P></P><P>OCRD:</P><P>Noconcatenate</P><P>LOAD CustomerCode,</P><P>&nbsp; keepchar(GroupCode, '0123456789') as GroupCode,</P><P>&nbsp; <STRONG>ApplyMap('MapNames', keepchar(GroupCode, '0123456789')) As GroupName,</STRONG></P><P>&nbsp; Newsletter</P><P>RESIDENT TempOCRD;</P><P></P><P>DROP TABLE TempORCD;</P></BODY></HTML> Fri, 08 May 2015 14:33:06 GMT https://community.qlik.com/t5/QlikView/Combine-Columns-Rows-Business-One-OCQG-OCRD/m-p/904065#M1008507 jonathandienst 2015-05-08T14:33:06Z