The column name is "Club Member" do i have to declare the variable as same as the column name?

Learn Academy Feedback
, , ,
1

club member
club member800Ă—600 31.9 KB

2

property
property800Ă—600 7.53 KB

3

csv
csv800Ă—600 52.3 KB

4

Hi @Swagasmini_Jena,

1.check in the read range activity did you checked Add header property
2. If yes please check in the Club Member header ending with space.

Regards,
Arivazhagan A

5

Yes it ends with space . i have posted the csv file

6

If end with space [Club Member ] like this you need to give or remove the space from the header and try again

7

The column C has come to Column d is this a problem? I can not make any change in the file and save in csv

8

No. Column header ending with space as you told earlier that is the problem

9

error2
error2800Ă—600 38.9 KB

10

getting the same error

11

Can you share the excel file and xmal file

12

Hi @Swagasmini_Jena,

I have seen that variable “names” content [First,Last,Club MemberJay,G… “Club Member” has not space at the end when you read your data.

The error is telling you that can not find "Club Member " (with space at the end) so for me is clear that you should use “Club Member” (without space at the end). Although, you previously post the select like this names.Select("[Club Member]='Yes'") and that gives you error too. Curious!

You can check the column name with names.Columns(2).ColumnName in a Message Box or Write Line

What if you use the column index instead of the name like this names.Select.Where(Function(x) x(2).Equals("Yes")) in this case “clubMembers” is an IEnumeble of DataRow

Have you tried using “Filter Data Table”?

image

1 Like