Forum Discussion
Custom column based on ranking
I need to create a new column called tech_id_padu in the below example. I need the column to take the highest rank for each askID and return the rating. I'm not sure how to write the logic for this...
Here's some sample data. I wasn't able to get it working. I filled in the tech_id_padu column with what the custom column should display. Thanks
askId aggregateTechPaduRating softwareName rating tech_ld_rank tech_id_padu
U006626 Discouraged Anacron NotRated 0 Unacceptable
U006626 Discouraged Apache Ant Discouraged 3 Unacceptable
U006626 Discouraged Chef Preferred 1 Unacceptable
U006626 Discouraged Firewall Preferred 1 Unacceptable
U006626 Discouraged Foomatic NotRated 0 Unacceptable
U006626 Discouraged IBM Business Process Manager Advanced Acceptable 2 Unacceptable
U006626 Discouraged IBM Global Security Kit NotRated 0 Unacceptable
U006626 Discouraged IBM JDK Unacceptable 4 Unacceptable
U006626 Discouraged IBM WebSphere Application Server Discouraged 3 Unacceptable
U006626 Discouraged IBM WebSphere Enterprise Service Bus - ESB Unacceptable 4 Unacceptable
U006626 Discouraged IPT Acceptable 2 Unacceptable
U006626 Discouraged Red Hat JBoss EAP Acceptable 2 Unacceptable
U018813 Discouraged Anacron NotRated 0 Discouraged
U018813 Discouraged Apache Lucene NotRated 0 Discouraged
U018813 Discouraged Apache Tomcat Preferred 1 Discouraged
U018813 Discouraged CMSutil NotRated 0 Discouraged
U018813 Discouraged Chef Preferred 1 Discouraged
U018813 Discouraged Finger NotRated 0 Discouraged
U018813 Discouraged Firewall Preferred 1 Discouraged
U018813 Discouraged FxLoad NotRated 0 Discouraged
U018813 Discouraged Mootools Discouraged 3 Discouraged| askID | software | rating | tech_Id_rank | tech_id_padu |
| U006626 | Foomatic | Acceptable | 2 | Unacceptable |
| U006626 | IBM JDK | Unacceptable | 4 | Unacceptable |
| U018813 | Firewall | Preferred | 1 | Discouraged |
| U018813 | Mootools | Discouraged | 3 | Discouraged |