Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I have a field called "Serial Number", and another one called "Flight time", I would like to make a Flight Time average per serial number, in the script...
How do I create that??
MainTable:
Load
[Serial Number]
[Flight time]
anotherField1
anotherField2
From TableName;
Join
Load
[Serial Number]
Avg[Flight time] as AvgFlightTime
Resident MainTable
Group By [Serial Number];
Please use Left Join instead of Join