Create a new new table from pre-existing one

[#1]

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

[Anil_Babu_Samineni]

One solution may be this

[#3]

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