Load Script - Error in expression: ')' expected

[SHomner]

Hy All,

i have this Problem in Tab2 :

Error in expression:

')' 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.

[brunobertels]

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
;

[SHomner]

Thanks @brunobertels  but i get the same error

[SHomner]

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

[Chanty4u]

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 

[brunobertels]

Hi 

Yes 

Your 're wright this syntax is not supported in script then Chanty4u's script seems better 

[SHomner]

I found where the Problem is : can not use Count with Total in Script just in Front End.

thanks you .