Import Excel

[#1]

So I have a series of excel files that I need to import into Qlikview. They hold times for CPU busy ranges based on day and hour as you can see in my sample.

I need to sort these out though. All the dates need to come in, along with the hours that they happened. I'm not sure how to capture the dates and hours correctly though, as some are in a column and others are in a row.

Thanks!

[#2]

So when loading a new version of excel, the fields come in as letters? Vs numbers with older versions?

[Anonymous]

Ethan,

there are several diffrences.  just try using wizard, you'll see.

Regards,

Michael

[schivet]

Hello,

I have the same problem with several excel loads. I use to read them everyday and since a few days, QlikView cannot find the last column! I have values in the column (xls). If I open the excel file, put a 0 in the last column and save it, it's working!?

Did you find the solution to your problem?

Thanks

Regards

Stéphane

[schivet]

Hello,

I have the same problem with several excel loads. I use to read them everyday and since a few days, QlikView cannot find the last column! I have values in the column (xls). If I open the excel file, put a 0 in the last column and save it, it's working!?

Did you find the solution to your problem?

Thanks

Regards

Stéphane

[schivet]

Hello,

I have the same problem with several excel loads. I use to read them everyday and since a few days, QlikView cannot find the last column! I have values in the column (xls). If I open the excel file, put a 0 in the last column and save it, it's working!?

Did you find the solution to your problem?

Thanks

Regards

Stéphane