How can i use case statement to solve for this scenario

ForSly

I am working on a requirement that requires me to find whether an employee applied to the same job name  more than once. If they apply to job name A with a job number 123  and the hiring manager decides they are more qualified for say the same job name but say a different job number , then  I need to assign a flag of N otherwise assign a Y. I am trying to use case statements but not sure if that's the right approach or even how to implement it. any suggestions?

Joel

My suggestion would be to implement this logic in the transactional system and your ETL will simply pull across the pre-calculated field.

ForSly

Good suggestion only problem is I didn't know how to implement that at the database level hence opted for analysis side and it appears as though I cant get it to pull the correct results

[Deleted User]

Do you have accesa to the RPD or is that also out of the question like solving this in the database?

ForSly

Yes I have rpd access.