Fusion Analytics Warehouse

Products Banner

Lookup the value from another column?

Received Response
50
Views
1
Comments
JobDeLuna
JobDeLuna ✭✭✭
edited October 2023 in Fusion Analytics Warehouse

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

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