You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insight (OBIEE) Tips | How to perform "VLOOKUP" in Insight

Received Response
65
Views
1
Comments
in Eloqua 1 comment

Similar to VLOOKUP ( or IF statements) in excel, this formula allows you to look up and retrieve information based on a comparison of columns.

It’s a great formula to have in your pocket for data hygiene initiatives or simply to compare data for inconsistencies.

To demonstrate how to build this formula we’re going to compare first and last name contact fields to ensure they do not have the same data.

Formula: CASE WHEN "COLUMN1"= "COLUMN2"THEN 'V1' ELSE 'V2' END

V1=  value you want to return if there is a

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!