Remedy Analytics ETL Developer interview questions

Someone submitted my resume and Remedy A called me. My 1st and 2nd interview went well, as they gave me a take home assessment after that. I received a great feedback on the assessment. Then they scheduled another interview with the VP of Eng’g. I think he’s from another company. He gave another assessment at the end of the interview. I got a perfect score. What I didn’t understand, if I didn’t do well, why would he give me an assessment at the end of the interview. I got a perfect score. The interviewer called me after few days to tell me that they would go a different path. It didn’t make sense. It was so frustrating bec I have invested time on those interviews, especially the take home test.