KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums KX Academy Problem with fundamentals capstone Data Analytics and Reporting,

  • Problem with fundamentals capstone Data Analytics and Reporting,

    Posted by Juanse on December 18, 2024 at 7:43 pm

    Hi i loaded the db with this command 

    system “l “,getenv[`HOME],”/fundamentals_capstone_dbs/2020.08.06”  </p><p><br></p><p><br></p><p>because i had problems loading it normal: </p><p><br></p><p>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

    • This discussion was modified 2 days, 20 hours ago by  Juanse.
    • This discussion was modified 2 days, 20 hours ago by  Juanse.
    mwoods replied 2 days, 4 hours ago 2 Members · 1 Reply
  • 1 Reply
  • mwoods

    Administrator
    December 19, 2024 at 11:18 am

    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 

Log in to reply.