Contents x
      QQ - Data Ingestion
      5 Articles  in this category
        • Print
        • Dark
          Light
        Contents

        QQ - Data Ingestion

        5 Articles in this category
        • Dark
          Light

        QQ - Can I load DateTime data in format DD/MM/YYYY HH:SS?

        Yes - use the CreateTableFromFile method, and set the default dateTimeFormat to be: "dateTimeFormat": "DD-MM-YYYY HH:MM", Date and DateTime formats DataJet will recognise any separator in Date or DateTime fields, so long as the separator used is...

        QQ - How do I load multiple files into the same table?

        Two options are available: Load each file by name Use Bulk import and load all files in a folder Both options assume that all files have identical field definitions and data-types. Option 1 - Load each file by name Set up a CreateTableFro...

        QQ - How many decimal points can I load into DataJet?

        By default, the precision of floating point numbers is set at 6 decimal places.    If necessary, it is possible to increase this to 10dp by modifying the server configuration file. Configuration File The server configuration file is call...

        QQ - How do I load JSON data into Datajet?

        Use the CreateTableFromJSON method.  Use primer to tell the method which data to load. { "method": "CreateTableFromJSON", "filename": "%DATAPATH%Demo_Modelling/BikeOverview/BikePoints.JSON", "fileIsArray": true, "table": "BikePoints",...

        QQ - How do I map NA and other null strings to NULL?

        This article will look at 2 scenarios: Unloaded Data Numeric Data loaded as String because of Null values Unloaded Data Where data has not yet been loaded, or where the data can be reloaded easily enough, the simplest action is to change the f...