Are there any functions to get the biggest value in a column? Like large function in excel?
Comments
-
Hello
Yes, but not a Function. A Function will look at every cell in a column independently. To do something to an entire column (or to multiple columns) you want to use a Workflow step (or related Explore action).
Group step is my first thought, change the aggregate from Count (the default) to Max
https://docs.experianaperture.io/data-quality/hosted-aperture-data-studio/get-started/explore-data/#groupLookup step can return the Maximum value from a reference data source
Profile can calculate the Maximum value for every column in a dataset
https://docs.experianaperture.io/data-quality/hosted-aperture-data-studio/use-cases/profile-and-understand-data/#all-statistics0 -
Hey Josh, that worked perfectly. The more I know the more I realise I don't know 😂
Thanks a lot for your patience
1
