topic Re: Importing from excel in QlikView

Importing from excel

Anonymous — Mon, 01 Jul 2013 16:31:06 GMT

I am trying to import a worksheet from excel that has 301,463 rows. When I add script RecNo() as RecordID.

Upon reload I only see 153,389 rows. I fully anticipate the reduction rows as there are several with blanks, however it isn't roughly half. I did use the transformation step

(

txt, codepage is 1252, embedded labels, delimiter is '\t', msq, header is 32 lines, filters(
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top

, 2)),
));

Re: Importing from excel

Gysbert_Wassenaar — Tue, 02 Jul 2013 17:49:10 GMT

txt, codepage is 1252,, embedded labels, delimiter is '\t',

That's for loading a text file with the fields separated by tabs, not for an excel file. Check that you're using the correct codepage and that the file doesn't contain special characters like unicode characters or unprintable characters.

Re: Importing from excel

Anonymous — Tue, 02 Jul 2013 19:00:40 GMT

Thank you very much. As I reviewed that very thing that is what I found. Made the correction and is working as intended.