Funds capestone exercise 2.3

Academy Support
1

Hi,
Trying to complete exercise 2 of the funds capestone project.

2.2) Below is the extractBrokerId function which seems to be passing all the test cases-

image
image328×220 2.39 KB

extractBrokerId:{

parts:"-" vs x;      
$[parts[0]~"CME";   
     "J"$ last parts ;
 parts[0]~"ISE";     
      "J"$ parts[1] ;
 0                   
]
}

Exercise 2.3 seems to be where the problem is , below is the query I wrote to update the messages table -

messages: update broker_id: extractBrokerId each string each exch_message from messages

image
image532×469 12.1 KB

image
image655×124 3.52 KB

Also noticed that trade_id column in messages table is not getting populated correctly it seems?
Kindly help.

2

Hi @diwan.work1902

Can you show me your code for 1.7? More importantly what datatypes you used for the two columns to import the messages.csv file?

Thanks!