I have inherited an excel database. approximate 18000 lines. about 250 columns. Approximate 200 columns contain numeric data, approx 50 columns that could be used as dimensions. Since reporting is coming in monthly, in this format from multiple places I can not change easily the set up of the file overnight.
table below shows some typical headings. No date column is included. For each month for each topic separate columns are created: OI budget, OI intake actual, OI Forecast, Backlog, Revenu budget, revenu realized,, revenu forecast I, etc
Order Intake Budget January 2017 (EUR)
Order Intake Budget February 2017 (EUR)
Order Intake Actuals September 2016 (EUR)
My idea is to use QV to clean up this file.
Would it be possible to for example have qlikview based on the heading:
- combine all "order intake budget xxxxxx" into 1 column
- create an extra date column which is filled with a date (Always 1st day of the month)