Foundation - Lesson 3 - Exercise 1

Hi all,
I am trying to manage exercise 1 lesson 3 from Foundation Level.
The requirement is to filter a column from a .csv file into an Assign activity.

The walkthrough says to add this expression — names.Select("[Club Member]= ‘Yes’ ") — into the Value field.
I get, however, the following error

Can anyone help? I tried to remove spaces, add ', remove them, add" but always getting the error.

what are the datatypes of both variables ?

Hi Prafull
names is DataTable
clubMembers is DataRow


In this case u need to use one more keyword that CopyToDatatable in end of the Condition.,

Please find the below example.

names.Select("[Club Member]= ‘Yes’ ").CopyToDatatable

Cheers…! :grinning::grinning::grinning:

Happy Learning :grinning:

1 Like

Are you sure? The exercise doesn’t say so…and I get a different error too

What is the DataType of ClubMember variable?

can you please check whether the column name is club member or not and also check that column has the value of yes.

Sequence1.xaml (7.2 KB)

I solved by changing the ’ character probably there is some conversion error from my keyboard.
I also added a message box activity to display the nickname variable (which was not provided in the exercise).

Please feel free to share with anyone who may have had my same issue or also please feel free to review