Hi, I am trying to filter the data based on the columns name, but when I give the same column name in the Filter Data Table it’s showing me Column Name is not set or Invalid.
Note. I am reading the data from the 11th row itself.
Actually, I have huge data in an excel.csv file. I am using filter the data from the 11th row based on the Column Name, and want to save in a new excel file.
HI @balkishan
Can I see the headers of your excel and how you have configured your filter data table activity?
Additionally, also make sure in the read range, you have ticked the include headers…
Are you sure you have checked the Add headers while reading the range?
or, there may be some spaces in the column names, so try copy and pasting the names from excel 
This is my excel headers, I am reading the data from the 11th row so that I can used the filter and it’s easy for bot to understand the header. Bcz I have to filter from the 11th row only.
If you see the 3rd column is type, I want to filter only type column and need only the Order and Shipping Services from this. If you can see Services are there below the type column, but I want to keep only Order & Shipping Services. And copy the complete data in a new excel file.
But didn’t resolve the issue, bcz I was busy with some other work. So I am working now on this.
@balkishan You can see in the filter data table column type there is one space you remove that
Just try after removing the space and newline after the column name manually just to check if that is the reason @balkishan
Fine
we can mention the column index as well like how we do in the assign activity
0 for the first column and rest
Kindly try mentioning the column index in the filter datatable wizard and let know for any queries or clarification
Hope this would help you
Cheers @balkishan
same error showing, I mentioned “2” in the field.
if you these are headers data, and the type is in the 2 position.
same error after removed the space.
Yes, it worked but not given me the filtered data, It’s showing only Headers name in the NewDT.
But I want data from the 12th row to till end.
Give me the empty excel file.
The we can try with a simple Select method
Like
dt = dt.Select(“ [columnname] = ‘yourvalue’ AND [columnname] = ‘yourvalue’ “ ).CopyToDatatable()
Make sure the column name is meant correctly
Is there any space before and after type in the columnname
We can check that with
Yourcolumnname.ToString.Length
If it is five then there is a space so kindly check that with the writeline before using this select method
Cheers @balkishan
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu