Issue in Updating the values for an Particular Column in INFOTABLE !!

Question

I have an INFOTABLE, with Column Names RT-1, RT-3, RT-2.Issue 1: Client want the Order of the Fields/Columns to be RT-1, RT-2, RT-3.Issue 2:

var oldEntry = new Object();
oldEntry.RT-1= startDate; //ERROR, SINCE RT-1 has "-" in the middle.

Thanks !!

pshashipreetham · Accepted Answer

Due to Pivot the Columns order got Changed, Since my datashape as Field name in order, I have Created an Datashape based empty INFOTABLE, then I merged it with the INFOTABLE who columns were not in Order, That solved my Issue.

//Create INFOTABLE based on DataShape
var params_forOrder = {
infoTableName : "InfoTable",
dataShapeName : "datashapeName" //Since DataShape has the Value Fields in Order, new Table will be in Ordered Columns
};
var table2 = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params_forOrder);
table2.AddField({ name: "timestamp", baseType: "DATETIME" });
//table1 has unordered table
var params_Merge = {
	t1: table2, // Empty INFOTABLE 
	t2: table1 // Unordered INFOTABLE
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Union(params_Merge);

SachinSharma · Answer

I created a infotable with column name RT-1, RT-2, RT-3 and I am able to add values for all the columns. I used below code,

var params = {
infoTableName: "TestInfoTable" /* STRING */
};

//result: INFOTABLE
var result = Resources["InfoTableFunctions"].CreateInfoTable(params);

var newField;

newField = new Object();
newField.name = "RT-1";
newField.baseType = 'STRING';
result.AddField(newField);

newField = new Object();
newField.name = "RT-2";
newField.baseType = 'STRING';
result.AddField(newField);

newField = new Object();
newField.name = "RT-3";
newField.baseType = 'STRING';
result.AddField(newField);

var newEntry = new Object();
newEntry["RT-1"] = "StartDate";
newEntry["RT-2"] = "Date";
newEntry["RT-3"] = "EndDate";
result.AddRow(newEntry);

Please check if above mentioned helps you achieve your use case.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.