Dataset: NoConcatenate LOAD * //Max(duration) as MaxValue Resident Import;
DROP Table Import;
I want the table to look like this:
How do I find the max value of a string of one cell? Not the entire set of data. I have tried Max() and MaxString() but as you know, it finds the Max of the entire data set for that field.
The max function works based on the group by clause at the end, if you have a column against which you need to find out the max value. Also, the above syntax seems to be incomplete without the group by clause, and after getting the max value you can right join the data against which you need to get the data.
Group by key;
Trial and error is the key to get unexpected results.