Forum Discussion
Custom column based on ranking
I need to create a new column called tech_id_padu in the below example. I need the column to take the highest rank for each askID and return the rating. I'm not sure how to write the logic for this...
Hi Anonymous ,
I'd suggest to do a grouping on askId with MAX tech_id_rank. Then join the result set with the original one and you should be good to go.
You may share some sample data or the file and I can support you further 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/