topic Sort data in different field at load in QlikView https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424112#M1155232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please help me out wit a code to be inserted into the script:</P><P></P><P>I have the following table to load</P><P></P><P>Code&nbsp;&nbsp;&nbsp; Name</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text1</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text2</P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text3</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P>238&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text5</P><P>239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text6</P><P>543&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text7</P><P>656&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text8</P><P></P><P></P><P>I need to load all the Names that has a code that starts with 1 into a filed named Code1_Names, the Names that has a code that start with 2 into filed Code2_Names. All the other names must not be loaded at all.</P><P></P><P>My table in Qlikview should look like this:</P><P></P><P>Table 1:</P><P>Code1&nbsp;&nbsp; Code1_Names</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text1</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text2</P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P></P><P>Table 2:</P><P>Code2&nbsp; Code2_Name</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text3</P><P>238&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P>239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text5</P><P></P><P></P><P></P><P>Thanks,</P><P>Nandor</P></BODY></HTML> Fri, 08 Mar 2013 22:13:10 GMT 2013-03-08T22:13:10Z Sort data in different field at load https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424112#M1155232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please help me out wit a code to be inserted into the script:</P><P></P><P>I have the following table to load</P><P></P><P>Code&nbsp;&nbsp;&nbsp; Name</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text1</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text2</P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text3</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P>238&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text5</P><P>239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text6</P><P>543&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text7</P><P>656&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text8</P><P></P><P></P><P>I need to load all the Names that has a code that starts with 1 into a filed named Code1_Names, the Names that has a code that start with 2 into filed Code2_Names. All the other names must not be loaded at all.</P><P></P><P>My table in Qlikview should look like this:</P><P></P><P>Table 1:</P><P>Code1&nbsp;&nbsp; Code1_Names</P><P>123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text1</P><P>124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text2</P><P>128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P></P><P>Table 2:</P><P>Code2&nbsp; Code2_Name</P><P>234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text3</P><P>238&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text4</P><P>239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Text5</P><P></P><P></P><P></P><P>Thanks,</P><P>Nandor</P></BODY></HTML> Fri, 08 Mar 2013 22:13:10 GMT https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424112#M1155232 2013-03-08T22:13:10Z Re: Sort data in different field at load https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424113#M1155233 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>PFA</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 08 Mar 2013 22:28:56 GMT https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424113#M1155233 MayilVahanan 2013-03-08T22:28:56Z Re: Sort data in different field at load https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424114#M1155235 <HTML><HEAD></HEAD><BODY><P>Thank you, it is exactely what I needed.</P><P></P><P>Beste regards,</P><P>N</P></BODY></HTML> Sat, 09 Mar 2013 06:09:06 GMT https://community.qlik.com/t5/QlikView/Sort-data-in-different-field-at-load/m-p/424114#M1155235 2013-03-09T06:09:06Z