Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The problem is that you caanot execute a count without a group by ...
Could you tell what kind of error returns the script?
What Error are you getting exactly?
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])
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])
The problem is that you caanot execute a count without a group by ...
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]);
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];
You right!
I 've write "Group By [Nom garage],[Date de création] ;"
and it's working
thank you very much