Skip to main content
G
Gucio16-Pearl
16-Pearl
September 24, 2018
Solved

how to sum values

  • September 24, 2018
  • 1 reply
  • 4023 views

hi all,

 

I would like to read values from csv file, and count sum of all values in each column.

please look at code below and give me answer - why commented row is wrong?? 

(The goal is to create dynamic dataShape with dynamic names of its column.) 

 

var fileRepository = Things["SystemRepository"];
var fileContent = fileRepository.LoadText({
path: "suma.csv" }
);
var rows = fileContent.split("\n");

var header = rows[0].split(",");
var columnsQty = header.length;
var myInfoTable = { dataShape: {fieldDefinitions : { } }, rows: [] };
var abc = 0;
var header_Sum;

for ( var i=0; i<2; i++) {
header_Sum = "Sum_" + i;

myInfoTable.dataShape.fieldDefinitions[header_Sum]={
name: header_Sum,
baseType: "NUMBER"
}
abc = abc + parseFloat(rows[i]);
};

//myInfoTable.rows.push({header_Sum:abc});

myInfoTable.rows.push({Sum_0:abc});
result = myInfoTable;

 

thx 

gucio

This topic has been closed for replies.
Best answer by CarlesColl

Build the row object before:

var newRow = {};
newRow[""+header_Sum] = abc;
myInfoTable.rows.push(newRow);

 

1 reply

C
CarlesColl1-Visitor
1-Visitor
September 24, 2018

Better you got with Infotable object instead of JSON infotable.

 

 

var fileRepository = Things["SystemRepository"];
var fileContent = fileRepository.LoadText({
path: "suma.csv" }
);
var rows = fileContent.split("\n");

var header = rows[0].split(",");
var columnsQty = header.length;
/*var myInfoTable = { dataShape: {fieldDefinitions : { } }, rows: [] };
*/
// -- Instead you should use the corresponding snippet:
var myInfoTable = Resources["InfoTableFunctions"].CreateInfoTable();

var abc = 0;
var header_Sum;

for ( var i=0; i<2; i++) { 
header_Sum = "Sum_" + i;
/*
myInfoTable.dataShape.fieldDefinitions[header_Sum]={
name: header_Sum,
baseType: "NUMBER"
}
*/
// -- Instead you should use the corresponding snippet
myInfoTable.AddField({ name: header_Sum, baseType: "NUMBER" });
abc = abc + parseFloat(rows[i]);
};

//myInfoTable.rows.push({header_Sum:abc});
/*
myInfoTable.rows.push({Sum_0:abc}); 
*/
// -- Instead you should use the corresponding snippet
myInfoTable.AddRow({ "Sum_0": abc });
result = myInfoTable;

But on your code I don't see it iterating over rows, it's right? You are iterating, if I understand well, over columns (2 columns) but not rows.

 

G
Gucio16-PearlAuthor
16-Pearl
September 26, 2018

hi,

 

My code was written just to ask how to do it. I couldn't find solution why infoTable was not populated with values when I used "dynamic" names of headers:

//myInfoTable.rows.push({header_Sum:abc}); - doesn't work;

myInfoTable.rows.push({Sum_0:abc}); - works;

 

Your code works perfectly - thx.

 

I am at the beginning of the road - so sometimes my questions may look strange, but not all is clear for me at the moment.

 

regards

 

C
CarlesColl1-Visitor
1-Visitor
September 26, 2018

use istead:

myInfoTable.rows.push({(""+header_Sum):abc}); - doesn't work;

Terms & ConditionsAccessibility statement