Replies

• kthorngren Posts: 20,275Questions: 26Answers: 4,765

  January 2022

  The column().data() docs state this:

  This method is used to get the data used for the cells in the column matched by the selector from DataTables.

  So its just a getter.

  Datatables doesn't have any API's to bulk copy data from one column to another. You will need to loop through the rows using rows().every() then copy the data in the loop. Don't use draw() in the loop. After the loop use draw() so the table is drawn only once.

  Kevin
• kthorngren Posts: 20,275Questions: 26Answers: 4,765

  January 2022

  Another option is to use the ColReorder extension. You can use the colReorder.move() move the columns. Not sure that is what you want though.

  Kevin
• N0tChris Posts: 7Questions: 0Answers: 0

  January 2022

  Thank you for your answer!

  I'm trying to apply your solution but I get another problem :

  function copyColumnLeft(table, currentColumn, withCodem) {
    var currentColumnIndex = currentColumn.index()
    if (currentColumnIndex < 1) {
      return
    }
    const currentVx = 'v' + currentColumnIndex / 3
    const prevVx = 'v' + ((currentColumnIndex / 3) - 1)
  
    let values = []
    table.rows().every(function () {
      const data = this.data()
      if (data[currentVx]) {
          values.push(withCodem ? data[currentVx]: data[currentVx].dem);
      }
      if (data[prevVx]) {
        // Here, I want to change values of data[prevVx] but I don't know how... 
        console.log(data[prevVx].dem);
      }
    })
  }
  

  I don't if I should use draw or an other DataTables function to change column values.
• kthorngren Posts: 20,275Questions: 26Answers: 4,765

  January 2022

  I'm not sure what you are trying to do in that function. Here is a simple example of copying one column to the other:
  http://live.datatables.net/detameqi/1/edit

  Click the button to copy the Office column to the Position column. Is this what you are trying to do?

  Kevin
• N0tChris Posts: 7Questions: 0Answers: 0

  January 2022 edited January 2022

  Thank you for your perfect answer.

  It fits perfectly with my needs!

  Thanks again!