Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Syed,
Did u find the solution.? If yes, please share with me the script.