When distinct API used for a column, other columns data of infotable also should present in output

Hi @AP_10343008 

You can create query based on your distinct value and merge infotable into single table to get all columns value with distinct value of column1 & column2

// result: INFOTABLE 
let data = me.dummyData();


let params = {
 t: data /* INFOTABLE */ ,
 columns: "Column1,Column2" /* STRING */
};

// result: INFOTABLE
let distinctValue = Resources["InfoTableFunctions"].Distinct(params);

// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE()
let result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
 infoTableName: "InfoTable",
 dataShapeName: "testShape"
});

for (var i = 0; i < distinctValue.length; i++) {
 // Provide your filter using the format as described in the help topic "Query Parameter for Query Services"
 let query = {
 "filters": {
 "type": "And",
 "filters": [{
 "fieldName": "Column1",
 "type": "EQ",
 "value": distinctValue.rows[i].Column1
 },
 {
 "fieldName": "Column2",
 "type": "EQ",
 "value": distinctValue.rows[i].Column2
 }
 ]
 }
 };

 let params = {
 t: data /* INFOTABLE */ ,
 query: query /* QUERY */
 };

 // result: INFOTABLE
 let tempData = Resources["InfoTableFunctions"].Query(params);

 let params2 = {
 t1: result /* INFOTABLE */ ,
 t2: tempData /* INFOTABLE */
 };

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

}

/VR