topic Formatting Imported data from Excel in QlikView https://community.qlik.com/t5/QlikView/Formatting-Imported-data-from-Excel/m-p/473412#M176845 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>in the attached excel file I would need to take row 7 as field names and (this is what I do not know how) insert 3 new fields. </P><P>The first new field should be named like the fisrt 5 characters of cell A1 that is 'SERIE' and its values should be '274697' for all the rows.</P><P>Idem with the second and the cell A2 field name 'FECHA VUELO', values '07/05/13'.</P><P>and the third new field should be named 'RUTA' and should take 'MAD-PUJ' as values.</P><P></P><P>Then I would like to get rid of rows 1 to 6 and load table...</P><P></P><P>How should I manage the import wizard?</P><P></P><P>Thanks</P><P></P><P><IMG __jive_id="39454" class="jive-image-thumbnail jive-image" onclick="" alt="HEADERS.png" src="https://community.qlik.com/legacyfs/online/39454_HEADERS.png" width="450" /></P></BODY></HTML> Mon, 22 Apr 2013 10:32:09 GMT 2013-04-22T10:32:09Z Formatting Imported data from Excel https://community.qlik.com/t5/QlikView/Formatting-Imported-data-from-Excel/m-p/473412#M176845 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>in the attached excel file I would need to take row 7 as field names and (this is what I do not know how) insert 3 new fields. </P><P>The first new field should be named like the fisrt 5 characters of cell A1 that is 'SERIE' and its values should be '274697' for all the rows.</P><P>Idem with the second and the cell A2 field name 'FECHA VUELO', values '07/05/13'.</P><P>and the third new field should be named 'RUTA' and should take 'MAD-PUJ' as values.</P><P></P><P>Then I would like to get rid of rows 1 to 6 and load table...</P><P></P><P>How should I manage the import wizard?</P><P></P><P>Thanks</P><P></P><P><IMG __jive_id="39454" class="jive-image-thumbnail jive-image" onclick="" alt="HEADERS.png" src="https://community.qlik.com/legacyfs/online/39454_HEADERS.png" width="450" /></P></BODY></HTML> Mon, 22 Apr 2013 10:32:09 GMT https://community.qlik.com/t5/QlikView/Formatting-Imported-data-from-Excel/m-p/473412#M176845 2013-04-22T10:32:09Z Re: Formatting Imported data from Excel https://community.qlik.com/t5/QlikView/Formatting-Imported-data-from-Excel/m-p/473413#M176846 <HTML><HEAD></HEAD><BODY><P>See attached example</P></BODY></HTML> Mon, 22 Apr 2013 19:17:16 GMT https://community.qlik.com/t5/QlikView/Formatting-Imported-data-from-Excel/m-p/473413#M176846 Gysbert_Wassenaar 2013-04-22T19:17:16Z