Data Tranformation in Azure ML

Copper Contributor


I store edge device data into Cosmos DB and import the same in Azure ML 

Imported DB appears with columns  TimeStamp , Name , Value . However for same timestamp, there are as many rows as there are Names like shown in image (ds.Jpg) .

However for ML  downstream processing, we would need the data as 1 Row for each Timestamp , with paramters name as columns

Timestamp , Parameter1, Paramet2,Parameter3

6/10/21 12:23:00 3.3             4.3            5.4

6/10/21 12:23:01 3           2 ......

so how do such a transformation in ML studio

I tried  Import Data -> Convert to Dataset ->SQl Transformation

But I was not able construct the sql query for it






0 Replies