topic Re: dynamic table creation and inserting values in it inside a script. in QlikView

dynamic table creation and inserting values in it inside a script.

Thu, 24 Jan 2013 10:54:29 GMT

Hello techies,

Can any one help me out in creating a table dynamically inside the script.

Let me explain my situation clearly first.

I have 2 plants consisting of 20 and 25 QVDs each(some qvds are common in both the plants)

I have to load these qvds into qlikview and concatenate the common qvds and store this again in the form of a qvd.Besides this I have to store other uncommon qvds as well.

For these I used 2 For loops for loading both the plants QVDs exclusively.At the same time I want to create a dynamic table with a single column containing all the QVD names so that I can concatenate the common QVDs by using these QVD names and store.

Any help is greatly appreciated.

Cheers.

Re: dynamic table creation and inserting values in it inside a script.

IAMDV — Thu, 24 Jan 2013 11:06:25 GMT

Hi,

Try using the below QlikView functions...

QVDTableName()

QVDNoOfFields()

QVDNoOfRecords()

QVDCreateTime()

QVDFieldName()

I hope this helps!

Cheers,

www.QlikShare.com

Re: dynamic table creation and inserting values in it inside a script.

Thu, 24 Jan 2013 11:48:55 GMT

Hi,

Thank you for the reply.

I want to create a table dynamically which consist of single column containing all the qvd names.

Later I want to use the qvd names in this table to store the data into another consolidated qvd.

Is this possible in Qlikview?

Thx.