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
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
thanks @Palaniyappan
did that work buddy
Any issues still
Cheers @Lam_Ha
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
thanks @venkat4u
It helped me a lot!
please make that as solution for your query.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.