topic Re: load only columns given in a seperate excel file? in QlikView

load only columns given in a seperate excel file?

Wed, 17 Jun 2015 08:20:01 GMT

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

Re: load only columns given in a seperate excel file?

Anonymous — Wed, 17 Jun 2015 10:07:28 GMT

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

Re: load only columns given in a seperate excel file?

tamilarasu — Fri, 19 Jun 2015 01:59:34 GMT

Hi Syed,

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