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

SQL to take out alternating rows for Risk and Impact?

Accepted answer


Subject Area: Workforce Profiles - Person Profile Real Time

Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss"

Content (required):

Hi All,

When using the Workforce Profiles - Person Profile Real Time subject area, we are pulling in columns "- Risk of Loss"."Impact of Loss" and "- Risk of Loss"."Risk of Loss". Impact and Risk data pulls from separate areas of the system and as a result - the data will not appear all on the same row. One row of data would exist for Risk, a second row existing for Impact.


Howdy, Stranger!

Log In

To view full details, sign in.


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