Repeated data excel

Hello,
Happy Holidays,

I have a question, I have an excel file with several data, which must be extracted to create an email, but these data are sometimes repeated in the event that they are repeated, the amount of data repeated in the same email must be attached, someone knows How can I determine how many repeating fields the excel has using uipath?

Hi @MICHAEL_URREGO

Can u show the sample excel file and final result u need ?

OF COURSE LOOK
IN EXCEL THE FIELD OF JUANITA PEREZ IS REPEATED BUT IT HAS DIFFERENT COMPANIES

THEREFORE, THE MAIL SHOULD REMAIN SO IN THE EVENT THAT A CONTRACT IS REPEATED AS IS THE CASE OF JUANITA PEREZ

Muestra.xlsx (8.4 KB)

Hi @MICHAEL_URREGO

let me know about how you want to determine the repeating fields i.e. on basis of which column and also
about that you want to count it or not
then I will share .xaml workflow
If possible then share large excel file

If any problem to share details here then you can ping me on my mail also.
sg2070156@gmail.com