Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Extracting Vertical, Program & Process from Department Field via FDI Formula - at Talent Acuqisition

Received Response
11
Views
1
Comments
Balachandra_Devadiga
Balachandra_Devadiga Rank 1 - Community Starter
in Oracle Fusion AI Data Platform Forum

Subject Area: HCM Talent Acquisition

In my “Department” field I have hierarchical values separated by underscores (“_”), for example:
IN_PS_009051_Customer Operations_Voice AM Pune_Comcast Inbound Pune Training
In this string:

  • Vertical = Customer Operations (3rd segment)
  • Program = Voice AM Pune (4th segment)
  • Process = Comcast Inbound Pune Training (5th segment)

Using FDI formulas, how can I:

  1. Extract the 3rd segment and assign it to a “Vertical” field,
  2. Extract the 4th segment and assign it to a “Program” field, and
  3. Extract the 5th segment (if present) for “Process”?

What is the correct syntax in Oracle FDI to split a string by “_” and reference the 3rd, 4th and 5th parts?

Tagged:

Answers

  • Jestin Rajan
    Jestin Rajan Rank 5 - Community Champion

    Hi, not sure if FDI supports any formula to perform this action, but I would have used Dataflows, which has a Split transformation function. It allows you to split values into columns using “_” as a delimiter and then keep only the required columns by renaming them.