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

Lookup the value from another column?

Received Response
142
Views
1
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited Aug 13, 2024 7:39PM in Oracle Fusion AI Data Platform Forum

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.