Problem with fundamentals capstone Data Analytics and Reporting,

https://learninghub.kx.com/forums/topic/problem-with-fundamentals-capstone-data-analytics-and-reporting

Hi i loaded the db with this command 

system "l ",getenv[`HOME],"/fundamentals_capstone_dbs/2020.08.06"  



because i had problems loading it normal: 


system "l ",getenv[`HOME],"/fundamentals_capstone_dbs/"

 returns: part



i tried to:  select from trade where date=last date , returns : date

the table trade doesnt have date i assume because i loaded from a date file , i need to load the db on the normal way

Hi Juanse, part indicates something is off with your directory structure. I logged into your environment as admin and using ls could check there was indeed an erroneous file "5457". I removed this file and was able to load the database.


This should work for you now, trade should be available to query


Thanks,

Michaela