Selecting variable columns from Excel

Fri, 06 Aug 2010 19:11:41 GMT

I am bringing in multiple Excel files into QV and wonder how to select only ceratin columns. If I bring in [Column Title] it works fine as Excel / QV can associate a column with a specific column. However I have a column title that varies from report to report as well as actual column. Here's a shot of the columns. I need get 2 columns Product Number & "yyyy-mm-dd Retail Units"

FL Ctgry

Product Number

Product Description

Part Number

This Year Retail Units

Last Year Retail Units

This Year Retail Dollars

Last Year Retail Dollars

2010-06-26 Retail Inv

2010-06-26 Corp Inv Units

Product Number is always in column 2 and is always called the same thing so it's easy. However column 2010-06-26 Retail Inv can be in column I, J or M and the name varies with the date of the report. The "Retail Inv" part is consitent. So I can't use @9 or the column name to get at the column I need.

I tried a transform to swap rows & columns but that did not seem to get me much further as I had a varaible numbers of fields.

Anyone have a hint on how to pull these 2 columns?

topic Selecting variable columns from Excel in QlikView

Selecting variable columns from Excel