there is one dataset which contains flight details like frictionreportdatetime, offsetdistance, offsetdirection, chainage, measuringspeed, cofvalue

in offsetdirection there is data like 9 for chainage from some values now the thing is i need to create a newcolumn with name offsetdirection using config table which looks like with cloumn names runway and oppositerunway with data 9, 14 in runway column and 27, 32 in oppositerunway column first we need to read first row which is 9 from config table which it will chunk the data from main dataset where offsetdirection is 9 then based on case statement it needs to create newoffsetdirection column in main dataset the case statement is like Case when chainage between min(chainage) and max(chainage/2) then ‘Runway’ when chainage between max(chainage/2) and max(chainage) then ‘oppositeRunway’ this is the usecase