Phones and emails make duplication rows
Summary
I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent
Hi,
I created an analysis in OTBI that shows employees phones and emails. So I created separate field for each phone type and email.
For example, for the Home mobile phone I used this formula -
CASE WHEN "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" = 'HM' THEN "Workforce Management - Person Real Time"."Person Phones"."Area Code"|| '-' ||"Workforce Management - Person Real Time"."Person Phones"."Phone Number" END
For Work mobile phone -
CASE WHEN "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" = 'WM' THEN "Workforce Management - Person Real Time"."Person Phones"."Area Code"|| '-' ||"Workforce Management - Person Real Time"."Person Phones"."Phone Number" END