Generating some excels filtered by the main excel

Hi folks,

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

list of James.xlsx (8.0 KB)
general list.xlsx (8.8 KB)

i have no idea how to reach, could you help me please??

thak you folks.

Hello,

Please check this following example: Main.xaml (12.4 KB)

1 Like

Hey @cacafundi

Have you checked ? below thread?

Regards…!!
Aksh

2 Likes

Hi folks,

florin.stan, thank you , but i cant download the file, when i click appear code line :slight_smile:

Aks, thank you, modifyng my workflow and adding your workflow it works perfectly :grinning:

BR.

Right click on link and click Save linked content as…

1 Like

Hi Florin,

certainly :man_facepalming:, sorry and thanks.:grinning:

BR.