Data Tranformation in Azure ML

%3CLINGO-SUB%20id%3D%22lingo-sub-2452869%22%20slang%3D%22en-US%22%3EData%20Tranformation%20in%20Azure%20ML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2452869%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20store%20edge%20device%20data%20into%20Cosmos%20DB%20and%20import%20the%20same%20in%20Azure%20ML%26nbsp%3B%3C%2FP%3E%3CP%3EImported%20DB%20appears%20with%20columns%26nbsp%3B%20TimeStamp%20%2C%20Name%20%2C%20Value%20.%20However%20for%20same%20timestamp%2C%20there%20are%20as%20many%20rows%20as%20there%20are%20Names%20like%20shown%20in%20image%20(ds.Jpg)%20.%3C%2FP%3E%3CP%3EHowever%20for%20ML%26nbsp%3B%20downstream%20processing%2C%20we%20would%20need%20the%20data%20as%201%20Row%20for%20each%20Timestamp%20%2C%20with%20paramters%20name%20as%20columns%3C%2FP%3E%3CP%3ETimestamp%20%2C%20Parameter1%2C%20Paramet2%2CParameter3%3C%2FP%3E%3CP%3E6%2F10%2F21%2012%3A23%3A00%203.3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B4.3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%205.4%3C%2FP%3E%3CP%3E6%2F10%2F21%2012%3A23%3A01%203%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2%20......%3C%2FP%3E%3CP%3Eso%20how%20do%20such%20a%20transformation%20in%20ML%20studio%3C%2FP%3E%3CP%3EI%20tried%26nbsp%3B%20Import%20Data%20-%26gt%3B%20Convert%20to%20Dataset%20-%26gt%3BSQl%20Transformation%3C%2FP%3E%3CP%3EBut%20I%20was%20not%20able%20construct%20the%20sql%20query%20for%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

 

 

 

0 Replies