Foundation Lesson3 Practice1

Learn Academy Feedback
1

Hi,

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!

2

Hi,

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

3

Thanks!!

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:

4

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