Fundamentals capstone ex 2.3

Community Support
,
1

Hmm… What `s the mistake?

2

Hi  !

In question 2.3, it states to update the messages table to include a new column ‘broker_id’. 

It does not state to update any other columns within the messages table.

Hope this helps.

Thanks,

Megan

3

Hi Megan!   

Unfortunately, it does not work ;/ . 

4

Hi ,

Do not edit your original update statement for broker_id.

Just remove the update trade_id portion.

If you have any more questions please let me know!

Thanks,

Megan

 

5

Hey Megan, if i understood you correctly - again Fail

6

It is the very last task from project that can not pass the test. I think i need to backup table “messages” but i do not know how. Can you give me recommendations please. Thanks for the help. 

7

Hi  ,

I think you’re right in that you have overwritten the original messages table and therefore aren’t able to get your version into the correct format. 

If you go back to the start of section 2 and read in the messages.csv again this will reset it and then you can make your changes.

You could maybe test your changes without overwriting the table e.g.

meta update broker_id … from messages

Then once you are happy with your changes, assign it to the “messages” variable. 

Please note: you are only being asked to update the broker_id column, you do not need to mention any other columns in your update statement. 

Hope this helps!

Laura

8

Hi Laura,

Thank you so much for your prompt response and helpful guidance! I was able to restore the original version of the messages table, and now I’ll be testing my changes following your suggestions.

Can you share me please the meta messages in console of correct variant. 

Thanks again, Dmytro

9

Hi  !

Please see below the meta for the updated messages table;

I see that this is correct in the screenshot you provided. Are you still receiving an error for 2.3?

Thanks,

Megan

10

Hey Megan! 

Unfortunately, stuck for a week on this assignment.

Thanks,

Dmytro

11

Hi ,

Can you download your project.md file and send it to me at mmcparland@kx.com ?

This is so I can properly assist you the best that I can.

Many thanks,

Megan  

12

Done