Skip to Content
0
Former Member
May 31, 2008 at 04:34 PM

Multi data providers (oracle DB and Excel file) in one BO report

86 Views

I have to create one BO report. There is one Excel file, with Type, type_ID,(each type has many different type_ids), eg

-


type type_id

IHEI IHEI121

IHEI IHEI132

IHEI IHEI212

IHDI IHDI511

IHDI IHDI232

IDWU IDWU212

IDWU ...............

.....

now I want to count the occurrences of these type_ids in the oracle database.

This should be relatively easy, with

select type, type_id, count(type_id)

from my_table

where type in ('IHEI', ...)

however, since the there are many more data in the database than in the Excel file, it will also count those type_ids that are not in the Excel file

So, how to get rid of those type_ids and keep only those coming from the Excel file?

thanks for your help!