Fundamentals Capstone 2.3

Community Support
1

Hello!

My extractBrokerId function works on the tests. However, when I try to update the message table, I get the “mismatched error type”. I checked the previous posts on this topic and I tried adding the broker_id and exch_message columns after the update command, but I still got the same error (screenshot attached).

I do not understand why this happens.

2

Hi  !

The update statement looks fine so I think it might be your extractBrokerId function that may be the problem.

Do you mind sending it over using the spoiler tag?

Thanks,

Megan

3

Of course! Here is the function (I checked it on the given input and it works. It also works when tested):

 

extractBrokerId : {[message] newStrs : vs[“-”; message];
result :0;
$[newStrs[0]~“CME”; result : “J”$newStrs[2]; result : “J”$newStrs[1]];
:result;
}

4

Hi ,

I’ve ran your code and both seem to work fine. If you’re still getting this error, can you download and send me your .md file at mmcparland@kx.com so I can have a closer look?

Many thanks,

Megan 

5

I hope the help given offline has resolved this issue.

Thanks,

Megan