Oracle Fusion Data Intelligence

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

Lookup the value from another column?

Received Response
139
Views
1
Comments
Rank 5 - Community Champion

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!



Answers

  • 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.

Welcome!

It looks like you're new here. Sign in or register to get started.