Capstone project 1.7 - KX Learning Hub

KX Academy

Capstone project 1.7

Posted by Akash on February 17, 2025 at 1:03 pm

Hello,

In the capstone project exercise 1.7, there is question

Using the Tables Importer (or otherwise) load into the current process the message.csv file and store in a table called messages. The csv is stored in the FP.Data module. The exch_message column should be read in as a string, and the trade_id column should be consistent with the trade table column of the same name.

While using the table importer to import the csv file I’m getting the below error and not able import that csv file.

Error ‘Failed to read table schema for source: length’

Please help me to resolve this isuue.

mwoods replied 1 month, 2 weeks ago 2 Members · 1 Reply
1 Reply

mwoods

Administrator
February 18, 2025 at 11:10 am

Hi @Akash thanks for flagging this issue with Table Importer, we will investigate.

Please try this alternative method in the meantime https://code.kx.com/q/ref/file-text/#load-csv

code.kx.com
File Text | Reference | kdb+ and q documentation - kdb+ and q documentation
File Text is a q operator that reads or writes text files.

Log In to Reply

Log in to reply.