Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Sakura
Contributor

need to use column from one excel in other

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!

Tags (3)
2 Replies

Re: need to use column from one excel in other

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;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sasiparupudi1
Honored Contributor III

Re: need to use column from one excel in other

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