Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
shiveshsingh
Honored Contributor

Qlikview Script

I have multiple QVDs in a folder

I need to have 5 columns from that qvds where  some column is having match condition.

Suppose if Column name like Test then load that column .

Can anyone help in the script?

3 Replies

Re: Qlikview Script

What do you mean by "Match condition on Column"?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP
MVP

Re: Qlikview Script

You could probably load the qvd table for 1 record and then use table functions [NoOfFields(), FieldName()] to iterate through all the field loaded in the table, store the field names in a variable and check for your condition and prepare a list of fields that you would finally need. 

 

satheshreddy
Contributor III

Re: Qlikview Script

Can you please give example of column condition.

Regards

Sathesh