Forum Discussion

pranjbhatt's avatar
pranjbhatt
New Contributor III
2 years ago

Select N largest from each group

Hi,  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 Aggre...
koryknick's avatar
koryknick
Employee
2 years ago

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

pranjbhatt's avatar
pranjbhatt
New Contributor III
2 years ago

Hi, 

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.  Note that date is in dd-MM-yyyy format.

 

INPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTconcentrix30-08-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
DIM_CLIENTenvizi27-08-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive
USERconcentrix29-08-202403-09-2024NowPositive
USER envizi27-08-202403-09-2024NowPositive

 

OUTPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive