What's new in Customer Journeys?

Connect and learn more! ×
Display multiple emails/phones on one row when there ae multiple records of the same type — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Display multiple emails/phones on one row when there ae multiple records of the same type

Received Response
29
Views
2
Comments
edited Apr 15, 2021 3:26PM in Reporting and Analytics for HCM 2 comments

Summary

Multiple emails/phones with multiple records

Content

Hi All,

I have built my query for displaying employee information with their different emails and different phone numbers. I created a Logical SQL that does several left joins to get the records into one row (this part is working well)

I have found several employees that could have 2 emails for Company Email or 2 work phones

Example

Work Email: [email protected]

Company Email: [email protected]

Company Email: [email protected]

Currently I have a rank on my phones and emails to return the first instance but I would like to let the users know that there is another email that might need to be verified

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!