How To Get A Datatable With Specified Columns Only In UiPath

Posted on by Sharath Raju

While dealing with data table operations, sometimes we might want to retrieve only specific columns from it.

How to do that?

dt_New=dt_Original.DefaultView.toTable(false,”Column1″,”Column2″,…)

Note:
Simply replace the “Column1″,”Column2” and so on with your required Columns

Example

Implementation using UiPath :

Let us implement a workflow which takes a “DataTable” and gives us out the “DataTable with specific columns“.

Step 1:
Drag “Build Data Table” activity into the design panel and populate it with some sample data.

UiPath Datatable with Specific Columns 1

UiPath Datatable with Specific Columns 2

Step 2:
Drag “Assign” activity into the design panel and fill it with above-mentioned code.

UiPath Datatable with Specific Columns 3

Step 3:
Drag “Message Box” activity to display the result
(Note: Here we have used LINQ to display the DataTable Instead of Output DataTable

string.join(System.Environment.NewLine, dt_YourDataTable.Rows.Cast(of DataRow).Select(function(row) string.join(“,”,row.ItemArray))))

UiPath Datatable with Specific Columns 4.PNG

Step 3:
Finally!!!

UiPath Datatable with Specific Columns 5.PNG

Click here to download the Source Code…

Hope it has helped you…

Published by Sharath Raju

I am an engineer by profession and by heart :) It's been 7+ years since I have been working with software development and robotic process automation. I have implemented close to 80+ RPA processes in total by using Uipath. It is so true that someone learns more by not reading something but by practicing the skill. I have been trying to understand exactly where people who are just starting out their career struggle and understand the pain of struggling for hours trying to figure something out.I can help you with that. Having a passion to share my piece of content, I have created step-by-step easy-to-digest courses. My goal is to help you get ready for the future by learning new talents and becoming more productive by providing you with relevant and useful courses. I'm still learning and exploring my field of work :) Every feedback should be as valuable as you are to me, please feel free to reach out to me if you have any feedback, questions, or need any help.Thank You...

Leave a Reply

%d bloggers like this: