Discussion Board for collaboration on QlikView Scripting.
i need to create a qvd file that has to be generated from 3 excel input files.
So the steps should be:
1. upload the 3 excel files
2. Create a new table with a specific logic that merges information from the 3 input files
3. Save the new table defined in the script as qvd
I am having trouble understanding which functions to use to complete step 2.
Can someone please help? Do you have some script example?
if you post the files and explain the logic of step 2..........
for step 2 you can concatenate (similar to sql union) or join (sameas sql), it depends on your requirement