Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am loading two tables from excel file (both are in same file just different sheet) like this :
Table1:
LOAD BI,
Subject,
Grade
FROM
[Some_Excel.xlsx]
(ooxml, embedded labels, table is Ispiti);
Table2:
LOAD BI,
Name,
LastName,
Address,
City
FROM
[Some_Excel.xlsx]
(ooxml, embedded labels, table is Studenti);
What i want to do is same as this SQL Query
Select City, AVG(Grade) as Average_Grade
from Table2
Join Table1 on Table1.BI = Table2.BI
Group By City
Oredr By Average_Grade;
Could anyone help me with this
If you determined to replicate a SQL like scenario for whatever reason you could go about it like this:
If you determined to replicate a SQL like scenario for whatever reason you could go about it like this:
Thanks this worked. I didn't know how to do this just using the table but now i know 😄
Excellent! I wasn't quite sure of your reason for trying to do what you asked so I tried to cover both bases.
Cheers,
Rod