How can I pass column number instead of column name in Filter DataTable activity?

Help
,
1

I need to filter a column with no header ie no column name, how can I refer to it in Filter DataTable activity with it’s column number . (eg. I need to get column ‘R’ with an empty header)

2 Likes
2

To identify column R: row(17).ToString

1 Like
3

Simply use the column index. In your case, 17, because the first column A starts at 0. In the filter wizard:

17 = x

2 Likes
4

Hi @saumyachh,

If you would like to filter a column according to column index without using filter datatable activity,
Please assign, Datatable DT1 =(From n in Your_Datatable.Select Where n(Column_Index).ToString.Equals("Filter_String") Select n).ToArray.CopyToDataTable

Regards,
Nimin

1 Like