topic Re: Selecting Data from an excel column in QlikView https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602479#M1102449 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In this case you can select columns at a time which you need in specific tables whichever columns you don't require just click on cross symbol at corner of each column header name at the time of loading.</P></BODY></HTML> Tue, 22 Apr 2014 08:31:29 GMT vijetas42 2014-04-22T08:31:29Z Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602472#M1102442 <HTML><HEAD></HEAD><BODY><P>i get monthly reports from the security departments where there are a few tables in the sheet. the column names are consistent but the amount of data are not.</P><P>but the thing about the tables is that it can start anywhere and i cannot define a cell... i know how to get data when they are laid horizontally using textbetween, right, left etc but is there anyway to get the data the same way when they are arranged horizontally</P><P></P><P></P><P>thank you in advance</P><P>Akhila de Costa</P></BODY></HTML> Tue, 22 Apr 2014 07:43:00 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602472#M1102442 2014-04-22T07:43:00Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602473#M1102443 <HTML><HEAD></HEAD><BODY><P>Can you show sample data?</P></BODY></HTML> Tue, 22 Apr 2014 07:51:25 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602473#M1102443 anbu1984 2014-04-22T07:51:25Z Re: Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602474#M1102444 <HTML><HEAD></HEAD><BODY><P>here there are 3 tables in one sheet... i want to get them as 3 seperate tables, is it possible?</P></BODY></HTML> Tue, 22 Apr 2014 07:59:22 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602474#M1102444 2014-04-22T07:59:22Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602475#M1102445 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Yes, At the time of loading Excel on the top you will find drop down list to select particular sheet from excel.</P><P>Every time you need to load excel with different sheets that will create 3 different tables</P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Tue, 22 Apr 2014 08:15:45 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602475#M1102445 vijetas42 2014-04-22T08:15:45Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602476#M1102446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>See the Table dropdown where you can select sheet name<IMG alt="Excel Sheet.png" class="jive-image" src="/legacyfs/online/57663_Excel Sheet.png" style="width: 620px; height: 254px;" /></P></BODY></HTML> Tue, 22 Apr 2014 08:25:53 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602476#M1102446 vijetas42 2014-04-22T08:25:53Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602477#M1102447 <HTML><HEAD></HEAD><BODY><P>the thing is there are a lot of tables in in one sheet.... i have to extract multiple tables from a single sheet </P></BODY></HTML> Tue, 22 Apr 2014 08:27:24 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602477#M1102447 2014-04-22T08:27:24Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602478#M1102448 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Tue, 22 Apr 2014 08:30:48 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602478#M1102448 MK_QSL 2014-04-22T08:30:48Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602479#M1102449 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In this case you can select columns at a time which you need in specific tables whichever columns you don't require just click on cross symbol at corner of each column header name at the time of loading.</P></BODY></HTML> Tue, 22 Apr 2014 08:31:29 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602479#M1102449 vijetas42 2014-04-22T08:31:29Z Re: Selecting Data from an excel column https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602480#M1102450 <HTML><HEAD></HEAD><BODY><P>the columns are not consitant with regard to the cell number... please see the attachment if possible</P></BODY></HTML> Tue, 22 Apr 2014 08:37:03 GMT https://community.qlik.com/t5/QlikView/Selecting-Data-from-an-excel-column/m-p/602480#M1102450 2014-04-22T08:37:03Z