Capstone project 1.7

Academy Support
1

https://learninghub.kx.com/forums/topic/capstone-project-1-7-2

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

2

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.