Split column excel file in UiPath

Help
1

I came across the forum about similar topics, but I could not find a complete answer to my question. I have an Excel table as follows:

username point
A 5
A 5
A 2
B 3
B 2
B 4
and I want to separate the data by username as follows:
username point
— —
A 5
A 5
A 2
I’d really appreciate your help if you could provide me with an approach or some example of this being completed.

Best Regards
lamh

2

Hi @Lam_Ha

Welcome to uipath community

Fine
we can use filter datatable activity to get the datatable with the filtered data
https://activities.uipath.com/docs/filter-data-table
mention the input datatable name
and mention the output datatable name and in condition mention the columns like this
“username” = “A”
like wise use
“username” = “B”

Cheers @Lam_Ha

1 Like
3

thanks @Palaniyappan

4

did that work buddy
Any issues still
Cheers @Lam_Ha

5

Hi @Palaniyappan
I tried it that way, and this is my result.Filter_Data_Table.zip (24.0 KB)
can you give me advice?
thanks @Palaniyappan

1 Like
6

@Lam_Ha,

PFA.

filter.xaml (4.5 KB)

2 Likes
7

thanks @venkat4u
It helped me a lot!

8

please make that as solution for your query.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.