Generating some excels filtered by the main excel


#1

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.


#2

Hello,

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


#3

Hey @cacafundi

Have you checked ? below thread?

Regards…!!
Aksh


#4

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.


#5

Right click on link and click Save linked content as…


#6

Hi Florin,

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

BR.