Copy DataTable

Help Activities
1

Hi Everyone ,
i am stuck in a problem.
that i am not able to using datatableDT.defaultview.totable(true,“city”).copytodatatable.
i am not getting the syntax with copytodatatable.

2 Likes
2

Please revert me as i am not having a solution.

1 Like
3

Hey @mohd_qamaruddin

No need of copy to table here as it’s already a table.

Thanks
#nK

4

Hi

welcome back to UiPath forum

Usually when you are using DefaultView we don’t need a copytodatatable

DefaultView.ToTable - will already convert it to datatable

So the expression will be like this

datatableDT = datatableDT.DefaultView.ToTable(True, “city”)

This will get the distinct value in column city and the final output datatable will be having only that City column
If FALSE is mention instead of TRUE in the above expression then it will give all the records from that city column

Hope this would help you
Cheers @mohd_qamaruddin

6

hello Palaniyappan,
thank you so much now i got the solutions.

7

Hi

It would be helpful for many for future referral if the right comment is marked as solution

Cheers @mohd_qamaruddin

8

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