USQL支持支点-寻找一个例子 [英] USQL support pivot - looking for an example

问题描述

我们需要使用USQL进行数据的动态数据透视.输入的数据如下所示

We have a requirement to do the dynamic pivot of the data using USQL. We have input data as below

id	   timestamp	 key	value
2	  1520300241230	 key1	100
2	  1520300241230	 key2	101
2	  1520300241230	 key4	103

2	  1530300241230	 key1	200
2	  1530300241230	 key2	201
2	  1530300241230	 key3	202

需要按如下所示进行转换

That needs to be converted as below

id	timestamp	key1	        key2	        key3	        key4
2	1520300241230	100		101		#		103
2	1530300241230	200		201		202		#

USQL支持枢纽吗?

Does USQL support pivot to do the same ? 

推荐答案

你好

看看这个线程，它可能就是您想要的:

Take a look at this thread, it may be what you are looking for:

https ://social.msdn.microsoft.com/Forums/zh-CN/3d0f64c9-82ce-4eec-8bee-de792562d530/dynamic-pivot-in-usql?forum = AzureDataLake

这篇关于USQL支持支点-寻找一个例子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！