Data table select multiple columns, no filter condition

[Karthick_Settu]

Check this posts.

Activities - Filter Table

DataTable.select() versus FilterDataTable activity

Hello, 1)Can you please explain the difference between DataTable.select() and filter Data table activity ? When to prefer each and what is more efficient?, as of now I know one difference i found is return type.It would be great if you attach workflows for corresponding 2)And also how to use Datatable.select type for string type of columns in data table I have given like this [image] getting issue [image] Thanks in advance.

How to custom sort a datatable

Where do you get an error? I personally didn’t try a complete workflow with data from Excel, just the datatable manipulations, and I don’t have it installed on this PC. My hunch is that the column names are not A, B, C and so forth, and this will raise an exception where you assign to myView.Sort. You can verify this with the Output data table activity, which will give you a String representation of the table that you can write to output.

Using DataView.ToTable Method as input to a Write Range

Hi there, I’m trying to extract a single column from a DataTable variable and to use this column as an input to a Write Range Activity. The following method should return a DataTable which could be used as an input, but I haven’t figured it out yet. The VB Expression for the Data Table input that would return a datatable made from the column 0 of a given dt DataTable variable would be something like dt.DefaultView.ToTable(false, dt.Columns(0).ColumnName) but it awaits an identifier ? I’ll k…