This will be done in the loading script. What i want to be able to do is to get the GPA from MAX(STRM) if it is not null.
Let me elaborate. If there is a value in 1830 , then pick up the GPA from there.
In this scenario, where the GPA in the highest STRM 1830 is null, i want to be able to get the GPA of 3.400 from STRM 1820.
EMPLID STRM GPA
1 1820 3.4
Any form of help is greatly appreciated.
Thank you for your time!
load * Inline
max(STRM) AS STRM
RESIDENT Data where GPA<>'NULL' group by EMPLID;