im trying to filter an excel by column in order to select all the rows related with that column.
this column is a responsible name, when i have the filter done i need to create one excel for each responsible with all his rows ( the main excel could have 30 responsibles and i need to filtrate in a loop all his rows and then create his excel, this recursively for every responsible ).
i tried with filter data table in uipath doc but i don’t know where i mistake.
please, could you help me a hand?.
i will attach the excels
this is the main excel
list of George.xlsx (8.1 KB)
and those should be the outputs generated
i have no idea how to reach, could you help me please??
thak you folks.