load only columns given in a seperate excel file?

[#1]

Hi,

I have a qlikview document where data loads from database, qvd and other excel spreadsheets. I have a seperete excel file where I have dimension names and aliases and table names.

What I want is to only load the fields that are available in the seperate excel file. For example, a qvd fiel might have hundred of fields but I would like to only load those fields that I have in the seperate spreadshet where I have the dimension names and aliases

Can someone guide me on how to create such a a script that loads only customized columns from source

Shah

[Anonymous]

Try this,

First read this separate excel file that you have and for each table create a Variable which will have the list of fields in a comma separated fashion.. like you would have in a load statement..

then use that variable in the load statement instead of the field names..

-Aadil

[tamilarasu]

Hi Syed,

Did u find the solution.? If yes, please share with me the script.