How to display a column dynamically from javascript array dynamically inside Jquery Datatables

Question

I have got a local JSON flat DataSource as shown below

var dataSet = [
    [
        "481.55",
        "10.40"

    ],
    [
        "561.30",
        "-2.55"

    ],
    [
        "368.20",
        "33.45"

    ]

];

And i am using Jquery Datatables to display Data in tabular format this way

 $(function()
  {

      $('#example').dataTable( {
        "data": dataSet,
        "columns": [
            { "title": "Price" },
            { "title": "Volume" }


        ]
    } );   

  })

This is my jsfiddle

http://jsfiddle.net/cv04pp37/9/

With this the data is shown in this way

**

Price   Volume
368.20  33.45
481.55  10.40
561.30  -2.55

**

I have got a javascript array as shown below where the first value refers to first value of the dataSet array and so on

var array_names =['ONE','TWO','THREE'];

My question is , Is it possible to display One more additional column Name in Jquery Datatables so that it looks like this

Name Price   Volume
ONE     368.20  33.45
TWO     481.55  10.40
THREE     561.30  -2.55

Rajesh B · Accepted Answer · 2015-01-28 11:01:01Z

1

The jquery datatables doesn't support adding columns dynamically but there is a feasibility to hide/filter the column if you don't want it. As per my knowledge, this can be achieved in 2 ways

Prepare the dataset(with 3 column values) and then initialize the datatable with the dataset.
create a table with 3 column headers in the view and fill the table with content on page load or fill the datatable through the ajax call.

edited Jan 28, 2015 at 11:01

answered Jan 28, 2015 at 10:46

Rajesh B

113 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pawan Over a year ago

I cannot go for the first Option as the dataset values will be returned from a backend server and i an't modify that . Could you please elaborate the second option a sample jsfiddle if you don't mind .

Pawan Over a year ago

With this fiddle jsfiddle.net/cv04pp37/13 , i am always getting only the first value from the array

Rajesh B Over a year ago

I have changed the dataSet a bit. this might help you. Fiddle here: jsfiddle.net/RajeshBoora/ktdj3u9r

Collectives™ on Stack Overflow

How to display a column dynamically from javascript array dynamically inside Jquery Datatables

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related