need to use column from one excel in other

[Sakura]

Like in SQL

Example:

select sum(x), dimID from Fact --- can join to Dim to get dimDesc

select dimID, dimDesc from Dim

My case: 

select sum(x), dimDesc1  from Fact - ExcelSource

select dimID, dimDesc, dimDesc1 from Dim - ExcelSource

I need to know how to get :

select sum(x), dimID from Fact joining on dimDesc1

Kindly help!

[Anil_Babu_Samineni]

May be this?

Qualify *;

Fact:

select sum(x), dimDesc1  from Fact;

Qualify *;

Dim:

select dimID, dimDesc, dimDesc1 from Dim;

Left Join (Fact)

Load Fact.Sum(x), Dim.dimID Resident Dim where Fact.dimDesc1 = Dim.dimDesc1;

[sasiparupudi1]

Use Applymap

MAP_DESC:

Mapping Load

DimID,

DimDesc

From Your Excel file

Fact

select

sum(x),

ApplyMap('MAP_DESC',DimID,'NA') as dimDesc1 

from Your Excel file

Group By DimID;

hth

Sasi