Re: Hello friends, How can I control which columns are loaded for a QlikView table from a file based on user input?
One way to do it would be to load the field names into QlikView and allow people to select what they want to load. Then, you can build the list of fields for your LOAD statement in a variable and use the variable in the script.
You may have to use Partial load, or apply other tricks to avoid losing your selected values at the beginning of the reload process. Or, you could have two documents - one document with the metadata (field names) and the other document that actually loads data into QlikView.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Austin, TX and Johannesburg, South Africa!