Converting csv file to data table but unble to access column name using datatablename.select("[column]")

Help Studio
1

converting csv file to data table but unble to access column name using datatablename.select(“[column]”)

2

Instead of column name try with column index
Index position starts with 0 for first column

@Sakhare_Ankita

3

like this
DataTable.Select(“[0]”)

4

@Sakhare_Ankita

if you want to select only one column,then try this

datatable.deafultview.totable(false,“ColumnName”).copytodatatable

or try with the below you need to pass a condition

dt.Select(“[Column2]>‘1’”).CopyToDataTable

hope this helps

5

I want to add filter in it but its showing assign column not found

6

@Sakhare_Ankita
First Using Output data table activity, try to print the Data table values.
And check in which format, csv file data getting read.
So after that we can add activities accordingly to filter & select columns

7

Yes ,first I checked with writing into excel for formate is correct or not.
Yeah its working now. :+1: