fundamentals capstone 2.3

KX Academy

fundamentals capstone 2.3

Posted by Kal8na on April 9, 2024 at 4:39 am

I have an issue when updating the message table. can you please tell me why?

messages: update brokerId: extractBrokerId each exch_message from messages

Kal8na replied 7 months, 1 week ago 2 Members · 9 Replies
9 Replies

megan_mcp

Administrator
April 9, 2024 at 8:47 am

Hi @Kal8na

This update statement seems correct, can you send me a screenshot of the error you’re receiving ?

Thanks,

Megan
Kal8na

Member
April 9, 2024 at 12:50 pm

It says error type: Mismatched types
megan_mcp

Administrator
April 9, 2024 at 1:37 pm

Hi @Kal8na

I believe the error lies in how you imported your messages.csv. It states in the question that “The exch_message column should be read in as a string”.

To do this in q we use the ( * ) character. So to adjust your import, change “SJF” to “**”.

Let me know if this works!

Thanks,

Megan
Kal8na

Member
April 9, 2024 at 1:47 pm

Yes, It worked Thanks!!!
Kal8na

Member
April 13, 2024 at 2:14 pm

My 2.3 test is fail. could you please give me a suggestion for that?
megan_mcp

Administrator
April 15, 2024 at 9:20 am
Hi @kal8na

Since you have adjusted your code to use ‘ * ‘ to read in your columns as strings, you no longed need the following cast statement:
```
messages: update trade_id: `$string trade_id from messages
```
As this is changes the format of the column from image_1 to image_2.

Let me know if this helps!

Thanks,

Megan
Kal8na

Member
April 15, 2024 at 12:48 pm

when I remove the statement you mentioned above. It looks like this and the 2.3 is still a fail. can you give any solution for this please? Is the type of the exch_message column is C or String? Mine one is showing the type of it as C.
megan_mcp

Administrator
April 15, 2024 at 1:30 pm

Hi @kal8na

Can you make sure your variable names match up with those that are given in the expected schema?

Thanks,

Megan
Kal8na

Member
April 15, 2024 at 2:13 pm

yes, That’s the issue. Thank You!!!

KX Community