KX Community

Find answers, ask questions, and connect with our KX Community around the world.

Home Forums KX Academy fundamentals capstone 2.3

  • 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 1 month, 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.

    • This reply was modified 1 month, 1 week ago by  Kal8na.
  • 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!!!

Log in to reply.