Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am pulling the project related KPIs from the Sharepoint folder and I am facing difficulties in using the count function.
I am not sure if we can use count function while loading XML Date. Details below
LOAD floor(ID) AS ID, COUNT(floor(ID)) AS COUNT FROM [lib://Analytics] (XmlSimple, table is [xml/data/row]) GROUP BY floor(ID);
Hi,
Its given me Invalid Expressions Error in Resident code.