Loading dynamic columns from a Excel-Sheet into a rel. data model
Hello,
I have a problem with the loading of dynamic columns from a Excel-Sheet.
There is a SAP-Report, that selects a great database once in a month. The results are stored in one Excel-Sheet. For the analysis with QlikView it's my task to transfer this table into a relational data model. But the problem is that some columns are dynamic. I only know the max. number of these fields, but I can't adapt the QlikView-Scipt every month. Has anyone here an idea how I can solve this problem?
I can think of two different approaches here. The first one is to connect to Excel using ODBC. I have never done that personally so this is just me guessing... It might be possible to achieve what you are looking for this way. The other approach is to write a VBScript function that returns the column names (separated with comma) from the Excel spreadsheet and call this function from your load-script, put the result into a variable and use variable expansion to create your dynamic load-statement.
Like I said, I haven't tried either one of these approaches but it might give you some ideas.
Enclosed is a small sample of what can be done. I am sure you would find it very interesting. This shows you what you can do in QlikView with some tricks.
