fundamentals capstone 2.3

[megan_mcp]

Hi @Kal8na

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

Thanks,

Megan

[Kal8na]

It says error type: Mismatched types

[megan_mcp]

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]

Yes, It worked Thanks!!!

[Kal8na]

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

[megan_mcp]

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]

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.

• This reply was modified 2 months ago by  Kal8na.

[megan_mcp]

Hi @kal8na

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

Thanks,

Megan

[Kal8na]

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