topic How do i remove unwanted fields from my already loaded data in QlikView

topic How do i remove unwanted fields from my already loaded data in QlikView https://community.qlik.com/t5/QlikView/How-do-i-remove-unwanted-fields-from-my-already-loaded-data/m-p/992398#M967825 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 499px;"><TBODY><TR><TD height="17" width="71">Channel</TD><TD width="64">Week</TD><TD class="xl85" width="64">Date</TD><TD class="xl86" width="64">Start Time</TD><TD class="xl86" width="64">End Time</TD><TD width="172"><STRONG>Description</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:00:00</TD><TD align="right" class="xl86">2:11:34</TD><TD>A</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:00:00</STRONG></TD><TD align="right" class="xl86"><STRONG>2:25:39</STRONG></TD><TD><STRONG>A</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:14:49</TD><TD align="right" class="xl86">2:19:58</TD><TD>A</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:23:08</TD><TD align="right" class="xl86">2:25:39</TD><TD>A</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:25:39</TD><TD align="right" class="xl86">2:39:58</TD><TD>B</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:25:39</STRONG></TD><TD align="right" class="xl86"><STRONG>2:55:54</STRONG></TD><TD><STRONG>B</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:43:43</TD><TD align="right" class="xl86">2:47:03</TD><TD>B</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:51:02</TD><TD align="right" class="xl86">2:55:54</TD><TD>B</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:57:54</TD><TD align="right" class="xl86">3:12:08</TD><TD>C</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:57:54</STRONG></TD><TD align="right" class="xl86"><STRONG>3:27:49</STRONG></TD><TD><STRONG>C</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:15:53</TD><TD align="right" class="xl86">3:19:23</TD><TD>C</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:23:03</TD><TD align="right" class="xl86">3:27:49</TD><TD>C</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:27:49</TD><TD align="right" class="xl86">3:34:35</TD><TD>D</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>3:27:49</STRONG></TD><TD align="right" class="xl86"><STRONG>3:57:39</STRONG></TD><TD><STRONG>D</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:38:20</TD><TD align="right" class="xl86">3:44:49</TD><TD>D</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:48:29</TD><TD align="right" class="xl86">3:57:39</TD><TD>D</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:59:39</TD><TD align="right" class="xl86">4:05:58</TD><TD>E</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>3:59:39</STRONG></TD><TD align="right" class="xl86"><STRONG>4:28:53</STRONG></TD><TD><STRONG>E</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">4:09:23</TD><TD align="right" class="xl86">4:15:12</TD><TD>E</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">4:18:32</TD><TD align="right" class="xl86">4:28:53</TD><TD>E</TD></TR></TBODY></TABLE><P></P><P></P><P>I have a above data where i want only second field of a particular 'description'. how will i be able to fetch only that part of data..??</P></BODY></HTML> Mon, 05 Oct 2015 06:18:28 GMT saniyask 2015-10-05T06:18:28Z How do i remove unwanted fields from my already loaded data https://community.qlik.com/t5/QlikView/How-do-i-remove-unwanted-fields-from-my-already-loaded-data/m-p/992398#M967825 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 499px;"><TBODY><TR><TD height="17" width="71">Channel</TD><TD width="64">Week</TD><TD class="xl85" width="64">Date</TD><TD class="xl86" width="64">Start Time</TD><TD class="xl86" width="64">End Time</TD><TD width="172"><STRONG>Description</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:00:00</TD><TD align="right" class="xl86">2:11:34</TD><TD>A</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:00:00</STRONG></TD><TD align="right" class="xl86"><STRONG>2:25:39</STRONG></TD><TD><STRONG>A</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:14:49</TD><TD align="right" class="xl86">2:19:58</TD><TD>A</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:23:08</TD><TD align="right" class="xl86">2:25:39</TD><TD>A</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:25:39</TD><TD align="right" class="xl86">2:39:58</TD><TD>B</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:25:39</STRONG></TD><TD align="right" class="xl86"><STRONG>2:55:54</STRONG></TD><TD><STRONG>B</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:43:43</TD><TD align="right" class="xl86">2:47:03</TD><TD>B</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:51:02</TD><TD align="right" class="xl86">2:55:54</TD><TD>B</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">2:57:54</TD><TD align="right" class="xl86">3:12:08</TD><TD>C</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>2:57:54</STRONG></TD><TD align="right" class="xl86"><STRONG>3:27:49</STRONG></TD><TD><STRONG>C</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:15:53</TD><TD align="right" class="xl86">3:19:23</TD><TD>C</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:23:03</TD><TD align="right" class="xl86">3:27:49</TD><TD>C</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:27:49</TD><TD align="right" class="xl86">3:34:35</TD><TD>D</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>3:27:49</STRONG></TD><TD align="right" class="xl86"><STRONG>3:57:39</STRONG></TD><TD><STRONG>D</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:38:20</TD><TD align="right" class="xl86">3:44:49</TD><TD>D</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:48:29</TD><TD align="right" class="xl86">3:57:39</TD><TD>D</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">3:59:39</TD><TD align="right" class="xl86">4:05:58</TD><TD>E</TD></TR><TR><TD class="xl87" height="17"><STRONG>CAT1</STRONG></TD><TD align="right"><STRONG>21</STRONG></TD><TD align="right" class="xl85"><STRONG>5/23/2015</STRONG></TD><TD align="right" class="xl86"><STRONG>3:59:39</STRONG></TD><TD align="right" class="xl86"><STRONG>4:28:53</STRONG></TD><TD><STRONG>E</STRONG></TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">4:09:23</TD><TD align="right" class="xl86">4:15:12</TD><TD>E</TD></TR><TR><TD class="xl87" height="17">CAT1</TD><TD align="right">21</TD><TD align="right" class="xl85">5/23/2015</TD><TD align="right" class="xl86">4:18:32</TD><TD align="right" class="xl86">4:28:53</TD><TD>E</TD></TR></TBODY></TABLE><P></P><P></P><P>I have a above data where i want only second field of a particular 'description'. how will i be able to fetch only that part of data..??</P></BODY></HTML> Mon, 05 Oct 2015 06:18:28 GMT https://community.qlik.com/t5/QlikView/How-do-i-remove-unwanted-fields-from-my-already-loaded-data/m-p/992398#M967825 saniyask 2015-10-05T06:18:28Z Re: How do i remove unwanted fields from my already loaded data https://community.qlik.com/t5/QlikView/How-do-i-remove-unwanted-fields-from-my-already-loaded-data/m-p/992399#M967826 <HTML><HEAD></HEAD><BODY><P>Create a new table and drop the original:</P><P></P><P>New:</P><P>LOAD * WHERE Counter =2;</P><P>LOAD</P><P>     Channel,</P><P>     Week,</P><P>     Date,</P><P>     [Start Time],</P><P>     [End Time],</P><P>     Description,</P><P>     autonumber([End Time], Description) as Counter</P><P>FROM</P><P>     Old</P><P>Order By</P><P>     Channel,</P><P>     Week,</P><P>     Description, </P><P>     Date,      </P><P style="font-size: 13.3333330154419px;">     [Start Time],</P><P style="font-size: 13.3333330154419px;">     [End Time]</P><P style="font-size: 13.3333330154419px;">;</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Drop Table Old;</P></BODY></HTML> Mon, 05 Oct 2015 12:26:35 GMT https://community.qlik.com/t5/QlikView/How-do-i-remove-unwanted-fields-from-my-already-loaded-data/m-p/992399#M967826 Gysbert_Wassenaar 2015-10-05T12:26:35Z