Foundation Lesson3 Practice1


Foundation Lesson3 Practice1 came across the following error:

Compiler error(s) encountered processing expression “firstName.Substring(0.3).ToUpper + lastName.Substring(0,3).ToUpper”.
Option Strict On disallows implicit conversions from ‘Double’ to ‘Integer’.

Changing the type to generic variable also did not help in resolving.

Please help!


Substring(0,3) use comma to separate the function parameter.


Completely missed that one!!

But now getting runtime error

“message”: “Assign: Cannot find column [Club Members].”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “21:34:33”,
“processVersion”: “1.0.0”,
“jobId”: “8f8a312f-2375-4084-b77f-1caecc93a425”,
“robotName”: “JAY”,
“machineId”: 0,
“fileName”: “Data manipulation”

any idea what am I doing incorrectly?

Found it…it should be [Club Member] and not Members…small thing but stops the whole process!
Sorry my bad!!:pensive:

Modify the column name to “Club Member” column name in your workflow : “Club Members”.