Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One solution may be this
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