creating a table in script from multiple sources

Anonymous — Thu, 30 Oct 2014 19:50:06 GMT

Hi,

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?

Re: creating a table in script from multiple sources

maxgro — Thu, 30 Oct 2014 20:06:36 GMT

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