topic Loading Multiple Excel Files - Rows not consistent in QlikView

Loading Multiple Excel Files - Rows not consistent

Mon, 15 Aug 2011 03:55:05 GMT

Hello,

I can load multiple excel files with multiple sheets. My problem however is that the start of the table with in the sheets is not consistent. The table usually starts on row 9, however there are instances in which the table starts at row 10, 15, 17, 22 etc. The field names are consistent if that helps.

Thank you,

Alex

Field Names are...

Name,

ID,

Account,

F5,

[Pay Code],

F7,

Money,

Hours,

Wages

Loading Multiple Excel Files - Rows not consistent

swuehl — Mon, 15 Aug 2011 08:03:07 GMT

Hi Alex,

if the rows above your content are empty, it should not be a problem (I believe QlikView will disregard the empty rows).

If they are not, you could try the input filters (best using the table file assistant, transformation steps, conditional delete).

Hope this helps,

Stefan

Loading Multiple Excel Files - Rows not consistent

Fri, 19 Aug 2011 08:06:27 GMT

Hi Alex,

I agree with swuehl. Perhaps the ID field is a key and you can use it to setup an import filter that keep only filled rows.

I used this trip many times and for me it work well, you have only to find the right field.

Best

The NPrinting Team