Select N largest from each group

Question

Hi,&nbsp;I am building a pipeline to select latest datetime from the data file. I also need the latest value for all source_code (essentially a groupby and then max value of within group). I tried Aggregate function to select MAX over datetime and in the GROUPBY field I added source_code but do not receive the intendent result.Is there other way ? I have sorted the columns I need to find MAX value.&nbsp;&nbsp;

koryknick · Answer

pranjbhatt&nbsp;- can you provide a small sample of input data and desired output to clarify your question?

pranjbhatt · Answer

Hi,&nbsp;Following is the sample data. I need to have latest last_date values for each of the source (source_code) and each of the target table.&nbsp; Note that date is in dd-MM-yyyy format.&nbsp;INPUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TARGET TABLESOURCE CODELAST DATE&nbsp;RUN DATELOAD STATUS&nbsp;TYPEDIM_CLIENTconcentrix03-09-202403-09-2024NowPositiveDIM_CLIENTconcentrix30-08-202403-09-2024NowPositiveDIM_CLIENTenvizi01-09-202403-09-2024NowPositiveDIM_CLIENTenvizi27-08-202403-09-2024NowPositiveUSERenvizi28-08-202403-09-2024NowPositiveUSERconcentrix02-09-202403-09-2024NowPositiveUSERconcentrix29-08-202403-09-2024NowPositiveUSER&nbsp;envizi27-08-202403-09-2024NowPositive&nbsp;OUTPUT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TARGET TABLESOURCE CODELAST DATE&nbsp;RUN DATELOAD STATUS&nbsp;TYPEDIM_CLIENTconcentrix03-09-202403-09-2024NowPositiveDIM_CLIENTenvizi01-09-202403-09-2024NowPositiveUSERenvizi28-08-202403-09-2024NowPositiveUSERconcentrix02-09-202403-09-2024NowPositive

Forum Discussion

Select N largest from each group

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?