Hi guys how can I take lead of marks as 92
for student_id=1 and subject=chemistry I want the lead as 92 which means it should the marks of math of student_id 1
Thanks but this is not the exact way for this solution in my opinion
Thanks for helping but this is not a reliable way to get solution in my opinion
then you have to post your expected result
I agree with @binuacs - this is the solution I would do, and we need clarity on your expected output to help further
How can we use lag(marks,2) in alteryx?