topic Re: Loading excel sheet columns and their values dynmaically into qlikview in QlikView

Loading excel sheet columns and their values dynmaically into qlikview

Maheshwar — Sat, 16 Nov 2024 20:59:04 GMT

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.

Re: Loading excel sheet columns and their values dynmaically into qlikview

rubenmarin — Thu, 25 Apr 2019 19:27:24 GMT

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

Re: Loading excel sheet columns and their values dynmaically into qlikview

Qrishna — Thu, 25 Apr 2019 20:20:56 GMT

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.

Re: Loading excel sheet columns and their values dynmaically into qlikview

Maheshwar — Fri, 26 Apr 2019 06:52:37 GMT

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.