本文介绍了PowerQuery:如何连接多个分组值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

非常类似于这个,而且我会评论询问@marc-pincince,但我没有声誉要求.

Very similar to this, and I would comment to ask @marc-pincince but I don't have the reputation require.

这是否适用于 3 列数据?我有 A、B、C 列.

Would this be adaptable for 3 columns of data?I have column A, B, C.

  • A = ID
  • B = 奖
  • C = 年

我需要的是新列 A 将所有 ID 分组,然后新列 B 显示 Award Year、Award Year、Award Year、Award Year 等.

What I need is to have new column A which groups all the ID's and then new column B which shows Award Year, Award Year, Award Year, Award Year , etc..

我尝试使用自定义列使用 =[AllData][Award][Year]还尝试使用 =[AllData]([Award]+[Year])

I tried using The Custom Column using =[AllData][Award][Year]Also tried using =[AllData]([Award]+[Year])

这两种情况都会导致错误.我能够让 [AllData][Award][AllData][Year] 单独工作.

Both of these result in errors. I was able to get [AllData][Award] and [AllData][Year] to work seperately.

你有什么想法吗?

谢谢,杰克

推荐答案

您需要创建一个将 Award 和 Year 连接在一起的列.为此,请确保这两列都是文本数据类型,然后使用公式 = [Award] & 创建自定义列 [AwardYear]" " &[年份].

You'll need to create a column that concatenates the Award and Year together. To do this, make sure both of those columns are a text data type and then create a custom column [AwardYear] using the formula = [Award] & " " & [Year].

完成此操作后,您可以按照与其他问题相同的步骤进行操作,但您将使用 [AllData][AwardYear] 作为自定义列.

Once you do that, you can follow the same steps as in the other question, except you'll use [AllData][AwardYear] for your custom column.

这篇关于PowerQuery:如何连接多个分组值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-21 14:52