Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy All,
i have this Problem in Tab2 :
')' expected
this is my Script :
Tab_1:
load
Field1 ,
Filed2
FROM [lib:/.....]
(qvd) ;
Tab_2:
load
Field1,
Field1&Field2 as Key2
Count(total <Field1> Field1) as Key1
;
I don't see what is wrong .
Can you please help.
Thanks in advance.
Hi
May be this
Tab_1:
load
Field1 ,
Filed2
FROM [lib:/.....]
(qvd) ;
Tab_2:
load
Field1,
Field1&Field2 as Key2 ,
Count(total <Field1> Field1) as Key1
resident Tab_1
;
Thanks @brunobertels but i get the same error
i thing this could be the problem : Count(total <Field1> Field1) as Key1
when i use "Count( Field1) as Key1 " without "total <Field1>" it works
Try this
Tab_1:
load
Field1,
Field2
FROM [lib:/path/to/your/source/file.qvd](qvd);
Tab_2:
load
Field1,
Field1 & Field2 as Key2
Resident Tab_1;
Drop
Table Tab_1;
You can use count function direct in front end
Hi
Yes
Your 're wright this syntax is not supported in script then Chanty4u's script seems better
I found where the Problem is : can not use Count with Total in Script just in Front End.
thanks you .