Capstone project - Incorrect formats

Community Support
1

Hi all,

I’m getting fails in multiple questions due to the table/dictionary being in an incorrect format although I believe they are in a correct format. For example 2.3 I have messages in the form 

c                              t f a
trade_id            C
exch_message C
broker_id            j

The question requires the cols to be string, string and long.

Other questions I am having this issue with are 3.3, 4.6, 4.7 and 5.3.

Thanks,

Gearoid.

2

https://community.kx.com/t5/KX-Training/Data-Cleaning-Capstone/m-p/11935#M117

https://community.kx.com/t5/KX-Training/Fundamental-Capstone-2-3/m-p/12693#M173 

These posts refer to the same section and may be of help

3

Hi Michaela,

Thanks for your reply.

The two posts above don’t really help, the table is correct I believe but the error idicates its in the wrong format enuogh though I believe it is, is there any other resource I could use so I can further debug the issue?

Thanks,

Gearoid.

4

If its happening for multiple questions it is odd behaviour.. Can you paste your output from running submitProject at the end so I can see all failing errors I will be better able to assist?

Also if you screengrab what a sample of your messages table looks like that would help? Agree the meta looks to match but perhaps there is some other issue.

 

 

5

Here is the output of submitProject and a sample of the messages table

 

6

trade_id does not need to be prefixed with 0 in the case of single digit numbers.

That should sort all those errors I would think

 

7

Hi Michaela,

I updated the table below and have attached the meta but the table is still failing

Thanks,

Gearoid.

 

8

Hi  i will reach out on DM to assist