Loading excel sheet columns and their values dynmaically into qlikview

[Maheshwar]

Hi All, i have requirement, i am getting two excel sheets in which one excel sheet i.e sheet 1 is about condition sheet and another excel sheet i.e sheet 2 is about data. i need output two columns from these two excel sheets i.e Id and Key in qlikview.

sheet 1 data : 

Id	Country	Product	Region
1	All
2	Business		markets
3		retail
4	medical	HR
5	School	telecom

sheet 2 data:

Country	Product	Region	Key
Business		markets	ieoeo
medical	adkjfkd	ueikei	qwbxhd
School	HR	OpenView	klisbx
qiwurier	telecom	qieuriqw	answer
qweuriew	ieuriewr	uueueie	llkoiuu
jeuruerie	ewrier	aerewrew	wsedfftt
ueieotprr	ieoep	nkjfkds	nmbhhkk

Note: the user will enter the values in sheet 1 so every time the columns and their values will change.

Requirement : from sheet 1, condition :

if Country=Business and Region = Markets then output should be the corresponding values of Column Id from sheet 1 and Key from Sheet 2 i.e from Condition sheet, 

Id	Country	Product	Region
2	Business		markets

after applying the above condition ,we get the result from Data sheet 2 is

Country	Product	Region	Key
Business		markets	ieoeo

 So i need output :

Id	Key
2	ieoeo

 Like this i need to get the output by using these two excel sheets and one more thing here is "every time all columns and their corresponding values will change in sheet1" means the user will enter the values in sheet 1 ,so i want output which i mentioned above in qvw from these two excel sheets.

[rubenmarin]

Hi it looks easy for id 2, just a join or mapping but... what's the expected output for id's 4 or 5?

[Qrishna]

You should make a composite Key.See attached.

Whenever there is a match of the composite keys from both the tables, After refresh of the App, you see your desired output.

[Maheshwar]

Hi Krishna,
Thanks for your reply but here i mentioned already, the columns in condition sheet will change because every time the columns is not constant so in this case, your script will not work . i want dynamically loading columns from condition sheet with condition and the result should give according to this columns.