Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
maxwellf
Contributor III
Contributor III

Buscar maiores valores de um campo agrupando por data e descricao

 

nr desc pto qtd data
399861 EST 40 9 2021-12-15
399861 EST 44 1326 2021-12-16
399861 EST 40 7 2021-12-22
399861 EST 40 16 2021-12-23
399861 EST 40 250 2021-12-29
399861 EST 40 1493 2021-12-30
399861 EST 40 8812 2022-01-06
399861 EST 44 9078 2022-01-06
399861 DED 30 9 2021-12-15
399861 DED 32 1326 2021-12-16
399861 DED 34 7 2021-12-22
399861 DED 30 16 2021-12-23
399861 DED 35 250 2021-12-29
399861 DED 35 1493 2021-12-30
399861 DED 30 8812 2022-01-06
399861 DED 31 9078 2022-01-06

 

 

Tenho uma tabela como esta, preciso trazer somente os valores em negrito.

A condição é buscar o maior valor do campo pto agrupando por nr, desc e data

Como faço isso no load?

 

 

Labels (1)
0 Replies