topic Read certain cell value and append it to an additional column? in QlikView https://community.qlik.com/t5/QlikView/Read-certain-cell-value-and-append-it-to-an-additional-column/m-p/665115#M242099 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>I have encountered a situation here:</P><P>There are over 40 excel files with similar names (CompanyX 07 2014.xlsx) in a folder, and I need to load all of them .</P><P>The header are on line 7 but I have to read a cell value (B2, it's the name of the company) and add it as the value of a auto generated column.</P><P></P><P>How can I achieve it ?</P><P></P><P>Thank you a lot!</P></BODY></HTML> Wed, 27 Aug 2014 19:14:53 GMT 2014-08-27T19:14:53Z Read certain cell value and append it to an additional column? https://community.qlik.com/t5/QlikView/Read-certain-cell-value-and-append-it-to-an-additional-column/m-p/665115#M242099 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>I have encountered a situation here:</P><P>There are over 40 excel files with similar names (CompanyX 07 2014.xlsx) in a folder, and I need to load all of them .</P><P>The header are on line 7 but I have to read a cell value (B2, it's the name of the company) and add it as the value of a auto generated column.</P><P></P><P>How can I achieve it ?</P><P></P><P>Thank you a lot!</P></BODY></HTML> Wed, 27 Aug 2014 19:14:53 GMT https://community.qlik.com/t5/QlikView/Read-certain-cell-value-and-append-it-to-an-additional-column/m-p/665115#M242099 2014-08-27T19:14:53Z