Mapping of data from two tables

[#1]

Hi all,

i have excel and database as a datasource.
in excel i have the data for different Business units for ex:ind,rus
below fields are in excel

ID,countrycode,BudgetI,CatID,PrgNM,CAtBudgetI,lcc,lcd,inncat,category etc..

i have 2 dimension tables
RT,RE

RT have following fields

RTtype,Dataelements

example

RTtype,    dataelements

1a ind 01, BudgetI,CatID
1b ind 02, CatID,prgNM,lcc
1c ind 03, lcd,lcc,inncat
1d ind 04,  lcd,lcc,Catid
...
2a rus 01,  Catid,lcd
2b rus 02,  lcd
2c rus 03, inncat,budgeti....

RE have following fields,

RTtype,BudgetI,CatID,PrgNM,CAtBudgetI,lcc,lcd,inncat,category

Problem ;

if i dont have value for category in excel i need to get value from RE table by
using RTtype and dataelements as a lookup and ineed to fetch value from RE by considering
priority of RTtype (example for ind:
first in need to consider 1a ind 01 ,i need to see if corresponding values of BudgetI,CatID
in both Excel and RE matched or not ,if matches then i need to pick corrsponding category from
RE,if it dd not match i need to go for second RTtype 1b ind 02, do the same for all business units)

Please Suggest a Solution.

attachments for excel and qvw

Thanks in Advance.

[#2]

hi all

its urgent .please suggest a solution

thanks.....