• KX Academy

  Capstone project 1.7

  Posted by Akash on February 20, 2025 at 7:26 am

  Hello,

  While using the table importer to convert the trade_id column datatype from byte to ‘Char’, it only converts up to 9 values. After the 9th value, it shows as ” “. Additionally, if I convert the trade_id column to String/General type, a comma is added up to the first 9 values, like ,”1″, ,”2″.

  Please help me resolve this issue. Please find the attached screenshot.

  Thanks,

  Akash G

  

  KDB_TableImporter_Screenshot1.png 35 KB Image File - Click to view

  Options

  • Copy Download Link

  

  KDB_TableImporter_Screenshot2.png 32 KB Image File - Click to view

  Options

  • Copy Download Link

  pgyorok replied 2 days, 6 hours ago 2 Members · 1 Reply
• 1 Reply

• 

  pgyorok

  Member

  February 20, 2025 at 10:29 am

  The “char” type can only hold a single character. So if you try to convert an input string that contains more than one character, such as “10”, it becomes the null value for char which is the space character. This is similar in principle to trying to convert a non-numeric string into a number.

  • This reply was modified 2 days, 6 hours ago by  pgyorok.

Log In to Reply