What's new in Customer Journeys?

Connect and learn more!
case statement was producing only 3 records instead of 6 records in FINAL_PATH Column — 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

case statement was producing only 3 records instead of 6 records in FINAL_PATH Column

Accepted answer
11
Views
4
Comments

Hi All,

need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTION column i have stored different report paths like., /shared/custom/hcm/....xdo.

Query:

SELECT DISTINCT FLV.MEANING as REPORT_NAMES,

FLV.DESCRIPTION , FLV.TAG,

--'https://'||POD.EXTERNAL_VIRTUAL_HOST||'/xmlpserver'||FLV.DESCRIPTION||'?_xmode=' AS REPORT_PATH_1,

-- 'https://'||POD.EXTERNAL_VIRTUAL_HOST||'/analytics/saw.dll?Portal&PortalPath='||FLV.DESCRIPTION AS REPORT_PATH_2,

 FLV.LOOKUP_CODE,

(

 CASE FLV.TAG

WHEN 'DASHBOARD' THEN '

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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