Answers

• kthorngren Posts: 21,364Questions: 26Answers: 4,956

  October 2017

  Here is an example I built previously to show how to dynamically get/build the table columns and data from an ajax request. Sounds like your situation is a bit different but I think this might help you get started.

  http://live.datatables.net/fafuyeyu/1/edit

  Kevin
• Revo Posts: 2Questions: 1Answers: 0

  October 2017

  Thank you!

  But I get the error "Uncaught TypeError: Cannot read property 'style' of undefined"

  var panelTableData;
  function generateStatsObject (selectedCropsAndYearsArray) {
  
      
  
      transformedObject = [];
  
      for (var i=0; i<selectedCropsAndYearsArray.length;i++) {
  
          transformedObject.push({title:selectedCropsAndYearsArray[i],data:selectedCropsAndYearsArray[i]});
              
      }
      
      console.log(transformedObject); 
      
      
      if (typeof panelTableData !== "undefined"){
  
          panelTableData.destroy();
  
      }
      
      panelTableData = $('#table_panels').DataTable({
          //data: transformedObject,
          columns: transformedObject
      });
      panelTableData.draw(); 
      
      
  }
  

  array of objects:

  (2) [{…}, {…}]
  0: {title: "Barley-2016", data: "Barley-2016", sTitle: "Barley-2016", mData: "Barley-2016"}
  1: {title: "Barley-2017", data: "Barley-2017", sTitle: "Barley-2017", mData: "Barley-2017"}
  
• allan Posts: 63,552Questions: 1Answers: 10,477 Site admin

  October 2017

  My guess is that transformedObject contains more entries than there are columns in the table, although without a test case showing the issue it is impossible to say for sure.

  Allan