topic Transforming data on an excel spreadsheet to load into Qlikview in QlikView

Transforming data on an excel spreadsheet to load into Qlikview

Thu, 06 Jan 2011 00:04:18 GMT

I am having issues formatting invoices to load into Qlikview. The invoices are in an excel format and manually changing the format of the excel spreadsheet is not an option.

The top 11 rows of each invoice are not needed and I know how to remove them. Row 12 contains my headers. On this invoice there are 3 separate containers labeled shipment 1,2,3 in column A. I inserted this column so please disregard when providing a solution.

For each shipment I need to associate DC, PO, Item and CBM to Date, Container and Vessel/Voyage. I have tried everything I know please help. I have attached an example invoice.

Thanks

Transforming data on an excel spreadsheet to load into Qlikview

Thu, 06 Jan 2011 09:29:17 GMT

Hi Cory,

please see the attached explanations.

Hope it´s what you are looking for.

Good luck!

Rainer

Transforming data on an excel spreadsheet to load into Qlikview

Thu, 06 Jan 2011 15:50:35 GMT

Rainer,

Thanks for the explination. I am still having issues. When i follow your steps and reload the document It only shows the 1st container number and not the other 3. My Qvw file is attached so you can see what I am doing.

Transforming data on an excel spreadsheet to load into Qlikview

Thu, 06 Jan 2011 16:12:42 GMT

Hi,

the only difference I see at the moment are:

(biff, header is 8 lines, embedded labels, table is Summary$, filters(

//(biff, embedded labels, header is 8 lines, table is Summary$, filters(

my statement contains "embedded labels" and yours not.

Second I deleted the first column directly in the excel file (column A) .

Try to work it out using the files I send in the ZIP.

Rainer

AW:Re: Transforming data on an excel spreadsheet to load into Qlikview

rbecher — Thu, 06 Jan 2011 16:46:03 GMT

Your qvw work fine (on MSO 2007 and QV 10 SR1, maybe you have selected this container?

- Ralf