Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Lookup the value from another column?
JobDeLuna
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!
0
Answers
-
@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.
0