Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Lookup the value from another column?

Received Response
136
Views
1
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited August 2024 in Oracle Fusion Data Intelligence

Hi,

Is there a way through calculation that will lookup the value from another column?

For example, I want to add a new column that if China Region Part is present in Other Region Part column and it will return 'Yes' else 'No'.

Thank you!


pats.PNG


Tagged:

Answers

  • JoseP-Oracle
    JoseP-Oracle Rank 3 - Community Apprentice

    @JobDeLuna - There is not VLOOKUP functions in OAC DV. You can achieve similar by creating left outer joins between the current table and one to be the VLOOUP in the dataset, then in the DV report you can filter by nulls in the VLOOKUP table to determine if the row did not have a match between the table and the VLOOKUP table.

    If both the table and the VLOOUP tables are the same, you can add the same table twice in the dataset and change the name of one in the dataset definition.