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 ?
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
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