Foundation - Lesson 3 - Exercise 1

[Stefano_Meola]

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.

[Prafull_B (Praf)]

@Stefano_Meola
what are the datatypes of both variables ?

[Stefano_Meola]

Hi Prafull
names is DataTable
clubMembers is DataRow

thanks

[David3 (David Rajkumar)]

@Stefano_Meola

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

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…!

Happy Learning

[Stefano_Meola]

@David3

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

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

[David3 (David Rajkumar)]

What is the DataType of ClubMember variable?

[Mohansadaiyapillai (Mohanraj S)]

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

[Stefano_Meola]

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