Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to include a sequence in the analysis of the set below. looking for the last record = Result: 126
Aggr (MaxString ({$ <[CodigoFilial] = {'$ (vCodigoFilial)'}>} Pesquisa), CodigoCliente, NomeCliente))
Max (Sequencia)?
CodigoFilial = 10, Verdade = maria, Sequencia = 126
To fetch the last Sequencia by set analysis to this:
Aggr (MaxString ({$ <Sequencia = {"$(=max(Sequencia ))"},[CodigoFilial] = {'$ (vCodigoFilial)'}>} Pesquisa), CodigoCliente, NomeCliente))
To fetch the last Sequencia by set analysis to this:
Aggr (MaxString ({$ <Sequencia = {"$(=max(Sequencia ))"},[CodigoFilial] = {'$ (vCodigoFilial)'}>} Pesquisa), CodigoCliente, NomeCliente))
vCodigoFilial = 11
LOAD * INLINE [
Cod_Cliente, Sequencia, Filial, Vendedor, Data
1, 10, 9, Ana, 15/01/2019
2, 11, 10, Paula, 16/01/2019
3, 12, 11, Sandra, 17/01 / 2019
4, 12, 11, Sandra, 18/01 / 2019
4, 13, 12, Geisa, 18/01/2019
];
if(Count(DISTINCT{$<[Filial]={'$(vCodigoFilial)'} >}Cod_Cliente),
Aggr(MaxString({$<Sequencia= {"$(=max(Sequencia))"},[Filial]={'$(vCodigoFilial)'}>} Vendedor), Cod_Cliente))
If possible put max (Data)
Result: 4, 12, 11, Sandra, 18/01/2019