fundamentals capstone 2.3

Academy Support
1

https://learninghub.kx.com/forums/topic/fundamentals-capstone-2-3

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

messages: update brokerId: extractBrokerId each exch_message from messages

2

Hi @Kal8na

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

Thanks,

Megan

3

It says error type: Mismatched types

4

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


5

Yes, It worked Thanks!!!


6

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

7

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


8

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.

9

Hi @kal8na

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

Thanks,

Megan

10

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