I’m new to UiPath RPA world, so forgive me if I’m asking something so stupid, but I can’t figure it out.
Let’s say I have Excel file with a following example data:
1001,http:…,comments,John Smith,John Doe
1234, http:…,coments,Bill Gates,Steve Jobs
1235, http:…,coments,Bill Gates,John Doe
I need to do the following:
read the Excel file, filter and extract all rows with the same Customer to the new Excel file, so I can email every customer with his own tickets in excel.
So, in example above, the result should be 2 new Excel files. One file for Bill Gates (with his 2 tickets) and one for John Smith (with his 1 ticket).
Of course, in real world scenario, I will not know all the customers names and how many different customers will be inside the starting Excel.
Thanks in advance,