repeated records

[#1]

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

[swuehl]

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.

[Gysbert_Wassenaar]

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;