Hi,
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
Thanks
