Hi,
what is the best tool to filter/retrieve only the latest from a certain column? I dont want to count allll of the records more than once only the katest.
I read about using summary tool? or what would be the best for this?
thanks
Hi @Hi2023
You'd want to use the summarize tool. You didn't say much about the data, but if you have a field that is a date or datetime data type, then using the 'Max' function would return the latest value. You could also play around with the 'Last' option to take the last value in a group.
https://help.alteryx.com/20223/designer/summarize-tool
If you have multiple columns with dates, you can also use an expression in the formula tool below.
max([Column1], [Column2])
For a single column, the Max option within the summarize tool would be the best option.
If I have mulitple groups with same acct and date (concatenated column) how do I pull only the latest from each group ?
@Hi2023 , In case of Group you can use summarize tool to pick the max and group by the column you have else you can also use sample tool if your data is in descending order and pick the first row and select the column on which you want to group by.
so I concatenate 3 columns date acct# and
then summary tool?
or use the formula to group them individually
max([egjCCT Date], [egj. CCT Date]) I used same column? since they are in same Colum now.
Would this apply for a column full of diff groups-by using summary tool max and then group by
