Alias renames the column names in the script. Let's see it with an example
Alias A as Name, B as Number, C as Date;
When you execute the above script the columns are renamed A as Name, B as Number, C as Date.
In table Test2 also this renaming happens.
Hope this helps you.
Hi! It sounds ridiculous, but if you add line
"load * from .... (qvd)"
it will be ok.
I've tested this example:
ALIAS F2 as FAFA;
where 1=1 ;
And thanks community for answer:
Yes. We lose velocity.
I think you can use this way:
1. Add 2 columns to excel
2. load first line from qvd. It's quickly;
3. using something like this
for i=1 to NoOfFields('t1')
If vFieldNAME=FieldFrom then
'$(vFieldNAME)' as field_name
Concat(field_name,',') as fields
So you get the fields list despite "*"
4. exctract fields value into variable "vFields" and build vLoad
let vLoad='load '&vFields&' from '&<Your qvd file>
So you can save velocity and set script dinamic.