topic Create a new new table from pre-existing one in QlikView

Create a new new table from pre-existing one

Wed, 25 Nov 2020 16:16:04 GMT

Hello

I need your help for the following

Looking at my "system visualization data model" I have the following tables, that are a results of a cross table I already did. The two table are linked thorough the "Account#" field

tab1

Account #	FeaturesRat	Rating
1	Switch on HL Satisfaction	3
1	Calibrate occluder Satisfaction	3
1	switch on level Satisfaction	1
2	Recirculate CPL Satisfaction	3
2	Change ration CPL Satisfaction	2
2	Change direction CPL Satisfaction	2
3	Zero calibration Satisfaction	3
3	Pressure level Satisfaction	2
2	Switch on system Satisfaction	1

tab2

Account #	featuresFreq	Frequency
1	Switch on HL time per case	1
1	Calibrate occluder time per case	1
1	switch on level time per case	0
2	Recirculate CPL time per case	1
2	Change ration CPL time per case	0
2	Change direction CPL time per case	2
3	Zero calibration time per case	2
3	Pressure level time per case	1
2	Switch on system time per case	1

Now, I would like to create a third table that summarizes the two reported above, like the following

Account #	Features	Frequency	Rating
1	Switch on HL	1	3
1	Calibrate occluder	1	3
1	switch on level	0	1
2	Recirculate CPL	1	3
2	Change ration CPL	0	2
2	Change direction CPL	2	2
3	Zero calibration	2	3
3	Pressure level	1	2
2	Switch on system	1	1

How should I do?

Thank you for your support

Re: Create a new new table from pre-existing one

Anil_Babu_Samineni — Fri, 14 Apr 2017 13:10:54 GMT

One solution may be this

Re: Create a new new table from pre-existing one

Fri, 14 Apr 2017 15:28:26 GMT

Thank you,

My question was: How should I do to link new features names (under the column titled Features) to the features name under the column "featuresRat" and "FeaturesFreq"?

Should I create a new map in the script? like the one below?

map1:

mapping load * inline [

FeaturesRat, Features

Switch on HLM Satisfaction, Switch on HLM

Calibrate venous occluder Satisfaction, Calib. venous occluder

Switch on level Satisfaction, Switch on level

....

and then add into the script
ApplyMap('map4',[FeaturesRat]) as Features,

??? I tried it but I was not able to upload data, the system returns an error