topic Re: Reformating Data Assistance in QlikView https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514473#M693501 <HTML><HEAD></HEAD><BODY><P>Use Concat(<STRONG style="background-color: #6690bc; color: #ffffff; font-family: Arial; text-align: -webkit-center;">Compa</STRONG><STRONG style="background-color: #6690bc; color: #ffffff; font-family: Arial; text-align: -webkit-center;">ny Names</STRONG>).</P></BODY></HTML> Thu, 27 Jun 2013 06:20:26 GMT 2013-06-27T06:20:26Z Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514471#M693499 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to know how to format the data below.</P><P></P><P>From</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company Names</STRONG></SPAN></TH></TR><TR><TD>ABC</TD></TR><TR><TD>DEF</TD></TR><TR><TD>PQR</TD></TR><TR><TD>XYZ</TD></TR></TBODY></TABLE><P></P><P></P><P>To<BR />ABC, DEF, PQR, XYZ</P><P></P><P>Please kind advise. Thank you very much!!</P></BODY></HTML> Thu, 27 Jun 2013 06:12:00 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514471#M693499 2013-06-27T06:12:00Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514472#M693500 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This expression should do the trick:</P><P></P><P>=Concat([Company Names], ',')</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Thu, 27 Jun 2013 06:18:54 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514472#M693500 jonathandienst 2013-06-27T06:18:54Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514473#M693501 <HTML><HEAD></HEAD><BODY><P>Use Concat(<STRONG style="background-color: #6690bc; color: #ffffff; font-family: Arial; text-align: -webkit-center;">Compa</STRONG><STRONG style="background-color: #6690bc; color: #ffffff; font-family: Arial; text-align: -webkit-center;">ny Names</STRONG>).</P></BODY></HTML> Thu, 27 Jun 2013 06:20:26 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514473#M693501 2013-06-27T06:20:26Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514474#M693502 <HTML><HEAD></HEAD><BODY><P>Hello Jon,</P><P></P><P>Thank you for your suggestion.</P><P></P><P>I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?</P><P></P><P>MOC_Entity:</P><P>Load MOC_OrderID,</P><P>MOC_OrgCoy as MOC_Entity</P><P>resident MOC_Headline;</P><P>Load MOC_OrderID,</P><P>MOC_TakeCoy as MOC_Entity</P><P>resident MOC_Headline;</P><P></P><P>Thanks!</P><P></P><P><A href="cid:image001.jpg@01CE7346.39C26830"></A></P><P></P><P>Jeremiah Lee</P><P>Product Manager for eWindow®, Global Trading Services</P><P></P><P>Platts</P><P>12 Marina Boulevard</P><P>#23-01, Marina Bay Financial Centre Tower 3</P><P>Singapore 018982</P><P>DID (65) 6530 6415 | Support (65) 6530 6530</P><P>Mobile (65) 9108 4192 | F (65) 6532 2700</P><P>Yahoo : jleeka75@yahoo.com&lt;mailto:jleeka75@yahoo.com&gt;</P><P>www.platts.com&lt;http://www.platts.com/&gt;</P></BODY></HTML> Thu, 27 Jun 2013 06:54:49 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514474#M693502 2013-06-27T06:54:49Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514475#M693503 <HTML><HEAD></HEAD><BODY><P>Hello Kumar</P><P></P><P>Thank you for your suggestion.</P><P></P><P>I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?</P><P></P><P>MOC_Entity:</P><P>Load MOC_OrderID,</P><P>MOC_OrgCoy as MOC_Entity</P><P>resident MOC_Headline;</P><P>Load MOC_OrderID,</P><P>MOC_TakeCoy as MOC_Entity</P><P>resident MOC_Headline;</P><P></P><P>Thanks very much!</P><P></P><P><A href="cid:image001.jpg@01CE7346.ED4E7510"></A></P><P></P><P>Jeremiah Lee</P><P>Product Manager for eWindow®, Global Trading Services</P><P></P><P>Platts</P><P>12 Marina Boulevard</P><P>#23-01, Marina Bay Financial Centre Tower 3</P><P>Singapore 018982</P><P>DID (65) 6530 6415 | Support (65) 6530 6530</P><P>Mobile (65) 9108 4192 | F (65) 6532 2700</P><P>Yahoo : jleeka75@yahoo.com&lt;mailto:jleeka75@yahoo.com&gt;</P><P>www.platts.com&lt;http://www.platts.com/&gt;</P></BODY></HTML> Thu, 27 Jun 2013 07:01:25 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514475#M693503 2013-06-27T07:01:25Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514476#M693504 <HTML><HEAD></HEAD><BODY><P>Hi Jon,</P><P></P><P>Please see attached file, which will explain what is the result I am trying to get..Thanks!</P><P></P><P></P><P><A href="cid:image001.jpg@01CE734B.916686C0"></A></P><P></P><P>Jeremiah Lee</P><P>Product Manager for eWindow®, Global Trading Services</P><P></P><P>Platts</P><P>12 Marina Boulevard</P><P>#23-01, Marina Bay Financial Centre Tower 3</P><P>Singapore 018982</P><P>DID (65) 6530 6415 | Support (65) 6530 6530</P><P>Mobile (65) 9108 4192 | F (65) 6532 2700</P><P>Yahoo : jleeka75@yahoo.com&lt;mailto:jleeka75@yahoo.com&gt;</P><P>www.platts.com&lt;http://www.platts.com/&gt;</P></BODY></HTML> Thu, 27 Jun 2013 07:33:16 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514476#M693504 2013-06-27T07:33:16Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514477#M693505 <HTML><HEAD></HEAD><BODY><P>Attached shows the result I am trying to get…any suggestions please?</P><P></P><P></P><P><A href="cid:image001.jpg@01CE734B.A7F1B4A0"></A></P><P></P><P>Jeremiah Lee</P><P>Product Manager for eWindow®, Global Trading Services</P><P></P><P>Platts</P><P>12 Marina Boulevard</P><P>#23-01, Marina Bay Financial Centre Tower 3</P><P>Singapore 018982</P><P>DID (65) 6530 6415 | Support (65) 6530 6530</P><P>Mobile (65) 9108 4192 | F (65) 6532 2700</P><P>Yahoo : jleeka75@yahoo.com&lt;mailto:jleeka75@yahoo.com&gt;</P><P>www.platts.com&lt;http://www.platts.com/&gt;</P></BODY></HTML> Thu, 27 Jun 2013 07:33:52 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514477#M693505 2013-06-27T07:33:52Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514478#M693506 <HTML><HEAD></HEAD><BODY><P>I am getting error. Please see email I send to you for explanantion.</P></BODY></HTML> Thu, 27 Jun 2013 07:43:42 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514478#M693506 2013-06-27T07:43:42Z Re: Reformating Data Assistance https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514479#M693507 <HTML><HEAD></HEAD><BODY><P>Please assist. I am getting errors</P></BODY></HTML> Thu, 27 Jun 2013 07:44:11 GMT https://community.qlik.com/t5/QlikView/Reformating-Data-Assistance/m-p/514479#M693507 2013-06-27T07:44:11Z