topic How to find a missing Row while loading data from Excel in QlikView

How to find a missing Row while loading data from Excel

madhubabum — Sun, 20 Sep 2015 14:23:45 GMT

Hi all

How to find Missing "Row Value" (Row 5) ( Value is existing or not ? )

Note :

Re: How to find a missing Row while loading data from Excel

sunny_talwar — Sun, 20 Sep 2015 14:27:22 GMT

What are you trying to find out? Your data starts from row number 6, why do you care about Row 5 here?

Re: How to find a missing Row while loading data from Excel

evan_kurowski — Sun, 20 Sep 2015 15:48:26 GMT

Hello Madhu,

In your image I don't see any of the cells for Excel row 5 populated. If the entire row of a spreadsheet is null, you cannot detect it by RowNo() using the File Import Wizard of QlikView. It will simply not generate a row during load and in all senses, will be completely null.

However, in cases where you expect that spreadsheets may be populated with fully empty rows in the data areas and you want to track Row numbers exactly as they correlate to the source spreadsheet, convert your connection to the Excel ADO ODBC connection. This connection will faithfully record every row in the spreadsheet whether it has data or not.

https://community.qlik.com/servlet/JiveServlet/showImage/2-600201-65777/20140829_Spreadsheet_recno_blank_handling_via_OD…

Re: Need to import blank lines from Excel Workbooks

Re: How to find a missing Row while loading data from Excel

agni_gold — Sun, 20 Sep 2015 15:48:32 GMT

Hi Friend ,

I thing you want this

PFA the attched file

Re: How to find a missing Row while loading data from Excel

marcus_sommer — Sun, 20 Sep 2015 18:36:17 GMT

I think it's a designed behaviour, see also: Re: Header lines in an Excel file to LOAD

- Marcus