Forum Discussion
Solved
Max with Text data
I need to get the Max (or latest) Version by FullBuildID, problem is the FullBuildID is not a numeric value so when I use Max it returns a 0. Here is a sample of my data:
| Product | Version | Full Build ID |
| A | 16 | 16.0.00.0023.03 |
| A | 16 | 16.0.00.0020.02 |
| A | 16 | 16.0.00.0020.03 |
| B | 16 | 16.1.00.0040.57 |
| B | 7 | 7.5.00.0000.00 |
Desired output:
| Product | Version | Full Build ID |
| A | 16 | 16.0.00.0023.03 |
| B | 16 | 16.1.00.0040.57 |
thanks in advance for your assistance!
You could create a new column like this:
FullBuildNum = SUBSTITUTE([Full Build ID],".","")
Switch the column to Whole Number.
1 Reply
You could create a new column like this:
FullBuildNum = SUBSTITUTE([Full Build ID],".","")
Switch the column to Whole Number.