I have two datasources, using them I need to create one datatable.

shubhi03

Hi,I have two datasources ,Lets say A and B. And I need to create one datatable using them. Some of columns should come from A and other columns should come from B.
Is it possible to create single datatable using two datasource?

bcrouzy

I had the same problem with 3 datasources, the solution I found it's to create an html table as you want it to be, and create dataTable with this table. Perhaps it's not the better solution but it worked for me.

jr42.gordon

If you could merge you two datasources into a single JSON

sourceData = [
  {
      A: {}
      B: {}
  },
  {
      A: {}
      B: {}
  },
  etc.
]

I think you could then use data and columns.data as such

.DataTable( {
    "data": sourceData,
    columns: [
       { 'data' : 'A.foo' },
       { 'data' : 'A.boo' },
       { 'data' : 'B.foo' },
       { 'data' : 'B.too' },
       { 'data' : 'A.moo' }
    ]
} );

Any additional formatting of the data would be accomplished using columns.render