帮助拼合输出 [英] Help in Flatten output

问题描述

我不熟悉SA和tryinig来构建Iot应用程序，但是由于遥测的格式，我无法展平查询输出

I am new to SA and tryinig to build an Iot Application, but because of format of my telemetry i am not able to flatten the query output 

正如您在上面的输入流中看到的那样，我正在获取 网关信息，带有2个信标遥测输入.我想要得到的是将结果弄平即键入gatewayFreegatewayLoad bleName rssi ibeaconTxPower电池. 我尝试根据使用where子句的类型使用2个作业，并在第二个引用Ist，但没有帮助.还研究了UDF函数，但没有得到任何路径.

as you can see in above input stream, i am getting  gateway info with 2 beacons telemetry input. what i am trying to get is flatten the result   i.e. Type gatewayFree gatewayLoad bleName rssi ibeaconTxPower battery.  I tried using 2 jobs based on type using where clause and refer Ist in second but no help. also took look at UDF function but not getting any path . Any help would be appreciated. 

推荐答案

，请帮助我澄清您的问题.是否要将网关中的数据与iBeacon中的数据合并?还请使用输入JSON和所需的输出JSON进行解释.

Please help me by clarifying your question. Do you want to merge data in gateway with data in iBeacon ? Please also explain with an input JSON and desired output JSON.

这篇关于帮助拼合输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！