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?
