Solved
[infotable] Can I merge record by a column
can I merge recode that same timestamp
this is code to table
let params = {
infoTableName: undefined /* STRING {"defaultValue":"InfoTable"} */
};
// result: INFOTABLE
let table = Resources["InfoTableFunctions"].CreateInfoTable(params);
newField = {
name: 'value1',
baseType: 'NUMBER'
};
table.AddField(newField);
newField = {
name: 'value2',
baseType: 'NUMBER'
};
table.AddField(newField);
newField = {
name: 'timestamp',
baseType: 'DATETIME'
};
table.AddField(newField);
// result: INFOTABLE
table2 = Resources["InfoTableFunctions"].CreateInfoTable(params);
newField = {
name: 'value1',
baseType: 'NUMBER'
};
table2.AddField(newField);
newField = {
name: 'value2',
baseType: 'NUMBER'
};
table2.AddField(newField);
newField = {
name: 'timestamp',
baseType: 'DATETIME'
};
table2.AddField(newField);
table.AddRow({value1:10,timestamp:1700000010000});
table.AddRow({value1:12,timestamp:1700000020000});
table.AddRow({value1:14,timestamp:1700000040000});
table2.AddRow({value2:100,timestamp:1700000010000});
table2.AddRow({value2:120,timestamp:1700000020000});
table2.AddRow({value2:140,timestamp:1700000040000});
params = {
t1: table /* INFOTABLE */,
t2: table2 /* INFOTABLE */
};
//
// result: INFOTABLE
Union = Resources["InfoTableFunctions"].Union(params);
result=Union;