Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

rpt_tableau__staff_attrition_details dupes #1227

Open
cbini opened this issue Jun 26, 2024 · 0 comments
Open

rpt_tableau__staff_attrition_details dupes #1227

cbini opened this issue Jun 26, 2024 · 0 comments

Comments

@cbini
Copy link
Member

cbini commented Jun 26, 2024

Does this indicate an upstream problem?

case
when
count(employee_number) over (
partition by employee_number, academic_year
)
> 1
and termination_reason
in ('Import Created Action', 'Upgrade Created Action')
then 'dupe'
else 'not dupe'
end as dupe_check,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant