Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
i have some records that are repeated in my table, how can i do to show the repeated data in another table?
example?
atendentes_link]:
load * inline [atendente, link
danilo torres, 6060
ramon rios, 7070
danilo torres, 7070
fabiola santos, 6060
jeferson, 7070
];
"danilo torres" is repeated, i wanna put the repeated data and show in another table.
thanks for your help
It depends what you want to achieve, but you can just create a list box in the front end of field atendente, and enable 'Show frequency' in list box properties - general tab. Sort by frequency desc.
Try:
atendentes_link:
load *, if(exists(atendente),1,0) as Flag inline
[atendente, link
danilo torres, 6060
ramon rios, 7070
danilo torres, 7070
fabiola santos, 6060
jeferson, 7070
];
Result:
load atendente
resident atendentes_link
where Flag =1;
left join(Result) load atendente, link as link2
resident atendentes_link;