Skip to Content
0
Former Member
Nov 17, 2012 at 09:01 AM

How to implement the vlookup functionality in Web Intelligence Rich Client?

621 Views

Hi,

My client have an existing Web Intelligence report, in order to modify it he had provided the excel sheet which includes the old columns along with new columns that needs to be added to the report. The new columns are based on other columns which are using vlookup functionality in excel.

There are Column1 and Column2 which I am able to calculate based on the existing columns on the report. But based on Column1 and Column2 values I want to fetch the Column3 value which I am not able to achieve it. I have created the lookup table in SQL database which includes the value of Column1, Column2 and Column3. I have attached the snapshot of the Worksheets of similar excel sheet that was provided by client.

Shall appreciate if anyone help me to find solution for above.

Thanks in advance 😊

Regards,

Pravin P. Kumbhar

Attachments

Lookup Table.JPG (153.8 kB)
Sheet1.JPG (158.7 kB)