Use datatables.net with javascript

Question

So I have a few javascript arrays, ex. array1 = [1,2,3] and array2 = [4,5,6] and I want these arrays to represent the column data, not row data like it wants. How would I make the table to look like:

This

I've been pulling my hair out all day, and I can't seem to find a solution......is this even supported?

Community · Accepted Answer · 2017-05-23 12:14:54Z

6

Going off aw04's good answer, here is a way to do it by creating a new array by transposing the columns and rows. Use this method if you are generating the table based on data you have in a javascript array.

var rows = [];

for (var i = 0; i < array1.length; i++) { 
    rows.push([array1[i],array2[i]]);
}

Just make sure that array1 has the same number of elements as array2.

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Aug 3, 2016 at 19:09

Cave Johnson

6,8805 gold badges44 silver badges62 bronze badges

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

2 Comments

aw04 Over a year ago

yep this is what i'd do actually if it will just create the table for you, my answer is probably an extra step

Lucky7Chess Over a year ago

Yeah that's an easy way too, push them together. Thanks!

aw04 · Accepted Answer · 2016-08-03 18:57:51Z

4

Simply output the data how you need it.

var rows = '';

for (var i = 0; i < array.length; i++) { //assumes equal size arrays
  rows += '<tr><td>'+array[i]+'</td><td>'+array2[i]+'</td></tr>';
  //or however you do this
}

answered Aug 3, 2016 at 18:57

aw04

11.2k11 gold badges60 silver badges92 bronze badges

5 Comments

Cave Johnson Over a year ago

He is using the datatables jquery plugin which accepts data as a javascript array. He just has to format his array differently.

Lucky7Chess Over a year ago

yeah, that uses html right?, but I was looking to use datatables.net or bootstrap tables for its added functionality......so I guess I just have to figure out how to reformat the array?>

aw04 Over a year ago

@Andrew In the most basic example it operates on an existing table, that's why i took this approach datatables.net/examples/basic_init/zero_configuration.html

aw04 Over a year ago

Really, it doesn't matter though. You could use the same logic to restructure the data instead.

Lucky7Chess Over a year ago

@aw04, that's a very clever approach. Maybe making that basic table and then converting it to the datatables.net might do the trick.....

Collectives™ on Stack Overflow

Use datatables.net with javascript

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related