topic Re: same name generation in columan in QlikView https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381263#M701484 <HTML><HEAD></HEAD><BODY><P>Load the file as 2 differnt tables.</P><P></P><P>See Sample</P></BODY></HTML> Mon, 27 Aug 2012 17:37:07 GMT 2012-08-27T17:37:07Z same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381261#M701481 <HTML><HEAD></HEAD><BODY><P>HI ,</P><P></P><P>I have one problem to do in qlikview .if any one knows pls help me.</P><P>this is the problem;</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt; text-decoration: underline;">source data</SPAN>:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD class="xl63" height="20" width="64">document id</TD><TD width="64">broker name</TD><TD width="64">serial no</TD><TD width="64">created on</TD></TR><TR><TD align="right" class="xl63" height="20">001</TD><TD>chandu</TD><TD align="right">1</TD><TD>16-9-2012</TD></TR><TR><TD align="right" class="xl63" height="20">001</TD><TD><BR /></TD><TD align="right">2</TD><TD>16-9-2012</TD></TR><TR><TD align="right" class="xl63" height="20">001</TD><TD><BR /></TD><TD align="right">3</TD><TD>18-9-2012</TD></TR><TR><TD align="right" class="xl63" height="20">002</TD><TD>vinodh</TD><TD align="right">1</TD><TD align="right" class="xl64">2/4/2012</TD></TR><TR><TD align="right" class="xl63" height="20">002</TD><TD><BR /></TD><TD align="right">2</TD><TD align="right" class="xl64">5/4/2012</TD></TR><TR><TD align="right" class="xl63" height="20">002</TD><TD><BR /></TD><TD align="right">2</TD><TD align="right" class="xl64">6/4/2012</TD></TR><TR><TD align="right" class="xl63" height="20">002</TD><TD><BR /></TD><TD align="right">4</TD><TD align="right" class="xl64">7/4/2012</TD></TR></TBODY></TABLE><P></P><P><STRONG style="color: #0000ff; font-size: 12pt;">what i need is Output should be like this in qlikview </STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD class="xl65" height="20" width="64">document id</TD><TD width="64">broker name</TD><TD width="64">serial no</TD><TD width="64">created on</TD></TR><TR><TD align="right" class="xl65" height="20">001</TD><TD>chandu</TD><TD align="right">1</TD><TD>16-9-2012</TD></TR><TR><TD align="right" class="xl65" height="20">001</TD><TD>chandu</TD><TD align="right">2</TD><TD>16-9-2012</TD></TR><TR><TD align="right" class="xl65" height="20">001</TD><TD>chandu</TD><TD align="right">3</TD><TD>18-9-2012</TD></TR><TR><TD align="right" class="xl65" height="20">002</TD><TD>vinodh</TD><TD align="right">1</TD><TD align="right" class="xl66">2/4/2012</TD></TR><TR><TD align="right" class="xl65" height="20">002</TD><TD>vinodh</TD><TD align="right">2</TD><TD align="right" class="xl66">5/4/2012</TD></TR><TR><TD align="right" class="xl65" height="20">002</TD><TD>vinodh</TD><TD align="right">2</TD><TD align="right" class="xl66">6/4/2012</TD></TR><TR><TD align="right" class="xl65" height="20">002</TD><TD>vinodh</TD><TD align="right">4</TD><TD align="right" class="xl66">7/4/2012</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #0000ff;"><STRONG>if any one know s pls let me know</STRONG></SPAN></P></BODY></HTML> Mon, 27 Aug 2012 17:06:33 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381261#M701481 Qlik__Vinodh 2012-08-27T17:06:33Z Re: same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381262#M701483 <HTML><HEAD></HEAD><BODY><P>Vinodh,</P><P></P><P>You need to use Transformation step as follows:</P><P></P><P>Directory</P><P><SPAN style="font-size: 8pt;">;<BR /><BR /></SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[document id]</SPAN><SPAN style="font-size: 8pt;">, <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">[broker name]</SPAN><SPAN style="font-size: 8pt;">, <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">[serial no]</SPAN><SPAN style="font-size: 8pt;">, <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">[created on]</SPAN><SPAN style="font-size: 8pt;"><BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /><BR />[..\..\..\..\..\..\..\Documents\QlikView\Test\script.xlsx]<BR /><BR />(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ooxml</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">embedded</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">labels</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">table</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">is</SPAN><SPAN style="font-size: 8pt;"> Sheet1, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">filters</SPAN><SPAN style="font-size: 8pt;">(<BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Replace</SPAN><SPAN style="font-size: 8pt;">(2, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">top</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">StrCnd</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">null</SPAN><SPAN style="font-size: 8pt;">))<BR /><BR />)); </SPAN></P><P></P></BODY></HTML> Mon, 27 Aug 2012 17:15:29 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381262#M701483 bgerchikov 2012-08-27T17:15:29Z Re: same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381263#M701484 <HTML><HEAD></HEAD><BODY><P>Load the file as 2 differnt tables.</P><P></P><P>See Sample</P></BODY></HTML> Mon, 27 Aug 2012 17:37:07 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381263#M701484 2012-08-27T17:37:07Z Re: same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381264#M701485 <HTML><HEAD></HEAD><BODY><P>Thank u very much .....it is working good</P></BODY></HTML> Mon, 27 Aug 2012 17:41:06 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381264#M701485 Qlik__Vinodh 2012-08-27T17:41:06Z Re: same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381265#M701486 <HTML><HEAD></HEAD><BODY><P>Here it is attached.</P></BODY></HTML> Mon, 27 Aug 2012 17:41:32 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381265#M701486 bgerchikov 2012-08-27T17:41:32Z Re: same name generation in columan https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381266#M701487 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Mon, 27 Aug 2012 17:42:11 GMT https://community.qlik.com/t5/QlikView/same-name-generation-in-columan/m-p/381266#M701487 Qlik__Vinodh 2012-08-27T17:42:11Z