topic Loading dynamic columns from a Excel-Sheet into a rel. data model in QlikView

Loading dynamic columns from a Excel-Sheet into a rel. data model

Fri, 12 Feb 2010 12:55:16 GMT

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?

Greetings

Anja

Loading dynamic columns from a Excel-Sheet into a rel. data model

Fri, 12 Feb 2010 16:53:28 GMT

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.

/Fredrik

Loading dynamic columns from a Excel-Sheet into a rel. data model

disqr_rm — Fri, 12 Feb 2010 17:01:58 GMT

Hi Anja,

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.

Hope this helps.