Joining/Loading Conditions of 2 tables

[dmohanty]

Hi All,

I have a scenario to load two different tables from Excel File into QlikView. The two tables have below metioned fields. Could some one please help me on How to Load or Join or Transform the tables into QlikView?

Do I need to Join or make a Link Table or any other suggestions?

Table 1 (From Excel 1):

Rev Class

Month

QUARTER

Com Code

Costctr

Final Vertical

SBU

CC Desc

Cust num

Cust Name

Group Customer Name

Geo

Final New SubVertical

Proj Type

Project Code

W B S Code

Acct Id

Acct Desc

Org Unit

Org Unit Description

Staffing %

Emp Code

Emp Name

Grade

Practice

Previous Exp(Yrs)

Previous Exp(Mon)

Wipro Exp(Yrs)

Wipro Exp(Mon)

SOW No

Customer Engagement Type

Project Classification

CRM Reference No.

Onsite BMMs

Offshore BMMs

Total BMM

Onsite rate

Offshore rate

Onsite revenue

Offshore revenue

Reimbursement

Pass through

Total revenue

Old Vertical

Bulge Mix

Total Years

Grp Cust Enagaement Revised

Table 2 (From Excel 2):

			Rev ( In Mn)		Rev ( In Mn)	Rev ( In Mn)	Order booking ( In Mn)			Order booking ( In Mn)
SBU	Corrected Name/Group Customer	Sum of FY14 (P)	Q1	Q2	Q3	Q4	Q1	Q2	Q3	Q4

Regards!

[PrashantSangle]

Hi,

I already go through this thread actually there is no need to go with cross table you can simply  load both the table .

Only one thing while loading 2nd table you have to do some transformation step means you have to select embedded label and remove fist 2 line then load it using SBU field name it will automatically link to each other.

I tried your excel sheet.

Just check in case you need