Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
IAMDV
Master II
Master II

Hi,

Try using the below QlikView functions...

QVDTableName()

 

QVDNoOfFields()

QVDNoOfRecords()

QVDCreateTime()

QVDFieldName()

I hope this helps!

Cheers,

DV

www.QlikShare.com

Not applicable
Author

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.