Script error

[#1]

Hello,

Could someone tell me what's wrong with this script please?

vSourcePath

=

'..\1. Sources';

AssAuto:

LOAD [Nom garage],

     [Date de création],

     count([Nom garage])as Counting  

FROM

'$(vSourcePath)\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh]);

Thank you

[alexandros17]

Could you tell what kind of error returns the script?

[shanky1907]

What Error are you getting exactly?

[#4]

I've got this message:

Invalid expression

AssAuto:

LOAD [Nom garage],

     [Date de création],

     count([Nom garage])as Counting  

FROM

'..\1. Sources\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh])

[#5]

I've got this message:

Invalid expression

AssAuto:

LOAD [Nom garage],

     [Date de création],

     count([Nom garage])as Counting 

FROM

'..\1. Sources\Ass Auto Marsh.xlsx'

(ooxml, embedded labels, table is [Ass Auto Marsh])

[alexandros17 · Accepted solution]

The problem is that you caanot execute a count without a group by ...

[Anonymous]

Hello!

you  can  try it!

SET vSourcePath='..\1. Sources\';

AssAuto:

LOAD [Nom garage],

     [Date de création],

     count([Nom garage])as Counting 

FROM

$(vSourcePath)Ass Auto Marsh.xlsx

(ooxml, embedded labels, table is [Ass Auto Marsh]);

[MK_QSL]

Use anyone of below

Let vSourcePath

=

'..\1.Sources';

Data:

LOAD [Nom garage],

     [Date de création],

     COUNT([Nom garage]) as Counting

FROM

[$(vSourcePath).xlsx]

(ooxml, embedded labels, table is [Ass Auto Marsh])

Group By [Date de création],[Nom garage];

or

Let vSourcePath

=

'..\1.Sources';

Data:

LOAD

     [Date de création],

     COUNT([Nom garage]) as Counting

FROM

[$(vSourcePath).xlsx]

(ooxml, embedded labels, table is [Ass Auto Marsh])

Group By [Date de création];

[#9]

You right!

I 've write "Group By [Nom garage],[Date de création] ;"

and it's working

thank you very much