Level 1, Lesson 3, Practice 1 - Club Member not found in CSV

Learn Academy Feedback
1

Hi Everyone,

I tried looking through the forum for assistance, but was unable to find it. Can you kindly help me with RPA Academy Level 1, Lesson 3, Practice 1?

I’m getting an error when I run the script that says:

 Source: Assign
 Message: Cannot find column [Club Members].
 Exception Type: System.Data.EvaluateException

When I go to the value expression editor I have (everything between the parenthesis is highlighted brown):

 names.Select("[Club Members]= 'Yes'")

What am I missing?

Thank you in advance,
Seth

2

Can you check if club members column exists in names data table.

3

I checked and it does. To be safe, I re-downloaded the file from UI to make sure no data was changed.

4

@scohn80215

Have u fixed this issue??? if so, kindly help me out for i am currently facing the same issue…

Source: Assign
Message: Cannot find column [Club Members].
Exception Type: System.Data.EvaluateException

5

Hi @Hendry_john,

This is because the column is actually called ‘Club Member’, not ‘Club Members’:
image
Changing your select to reference the column name should fix this!

This is the same issue for @scohn80215 as well. Let me know if this works for you!

1 Like