Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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.

2 Replies
Luminary
Luminary

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

Hi,

Try using the below QlikView functions...

QVDTableName()

 

QVDNoOfFields()

QVDNoOfRecords()

QVDCreateTime()

QVDFieldName()

I hope this helps!

Cheers,

DV

www.QlikShare.com

Not applicable

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

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.

Community Browser