How to map model to table when the structure is array based?

Question

I have my data as following:

{
    meta: {
              format: "csv",
              info: "desc",
              columns: [
              {
                  id: "Name",
                  type: "Text",
                  length: 32          
              }, 
              {
                  id: "Text",
                  type: "Text",
                  length: 128
              }]
          },
    rows: [
              ["John","xxxx"],
              ["Alpha","yyyy"],
              ["Beta","wwww"],
              ["Gamma","zzzz"]]
}

Now, I am struggling to map the records to a Table control as Columns and Rows. Column seems straight forward, straight map, but the rows since lacks a mapping to column I wonder what could be the simplest way.

Approach Steps:

Make a keys[] from column.id of each columns record.
Traverse the rows[]
Each loop, while keys.length create an object as {keys[j]:row[k]}
Push to an array
Recreate the original JSON but replace Rows arrays with Objects

I am really struggling to translate this into code specially at the rows[] parsing and creating Objects. Is there, I am sure there must be, an efficient way to achieve this.

Sreekanth · Accepted Answer · 2016-11-24 20:50:29Z

1

Here is what you could do. using Array.map and forEach.

var input = {
  meta: {
    format: "csv",
    info: "desc",
    columns: [{
      id: "Name",
      type: "Text",
      length: 32
    }, {
      id: "Text",
      type: "Text",
      length: 128
    }]
  },
  rows: [
    ["John", "xxxx"],
    ["Alpha", "yyyy"],
    ["Beta", "wwww"],
    ["Gamma", "zzzz"]
  ]
};


var columns = input.meta.columns.map((column) => {
  return column.id
});


var rows = input.rows.map((row) => {
  var obj = {};
  row.forEach((column, idx) => {
    obj[columns[idx]] = column;
  });
  return obj;
});

input.rows = rows;
console.log(input);

answered Nov 24, 2016 at 20:50

Sreekanth

3,13014 silver badges22 bronze badges

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

2 Comments

axiomtheorem Over a year ago

many thanks for the reply. This solution works absolutely bang on to get the desired result. Although, my question was a little more towards wondering if there is any smart way of doing the same in SAPUI5 data binding for Table without the need of pre-processing the data. But if thats not possible I'll mark this as the right answer.

Sreekanth Over a year ago

I m no expert on sapui5 at all. I wont be able to answer, if there is a better way to do it in SAPUI. However, in general, you need to have a transformer in place to convert from one structure to another. It could either be at server / client.

Collectives™ on Stack Overflow

How to map model to table when the structure is array based?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related