来自不同列的电源查询数据
我是Power Query的新手，我想进一步了解它。我面临以下问题。我的桌子看起来像这样（已经删除了空字段）：
Spalte 9“”和“ Spalte 10”持有我的投资组合份额（Komma分离）。
编辑：为了澄清，我希望得到这样的东西：
| | | | | |
|---|---|---|---|---|
| | | | | |
| Callebaut AG | CH0009002962 | 0,63 | Null | Null |
| Galenica AG | CH0360674466 | 0,58 | Null | Null |
| Givaudan SA | CH0010645932 | 1,24 | Null | Null |
| HelloFresh SE | DE000A161408 | 527.705,26 | 1,85 | Null |
| Kering SA | FR0000121485 | 431.145,00 | 1,51 | Null |
| Standard Chartered PLC | GB0004082847 | 4,610 117.699 ,50 | Null | 0,41 |
| Unilever PLC | GB00B10RZP78 | 42,305 315.241,76 | Null | 1,11 |
What i'm trying to get is this:
| Spalte2 | Spalte8 |
|---|---|
| CH0012410517 | 1,04 |
| CH0009002962 | 0,63 |
| CH0360674466 | 0,58 |
| CH0010645932 | 1,24 |
| DE000A161408 | 1,85 |
| FR0000121485 | 1,51 |
| GB0004082847 | 0,41 |
| GB00B10RZP78 | 1,11 |
我可以在PQ中使用哪种方式将ISIN与其投资组合共享匹配？多谢！ 托马斯
i am new to Power query and i would like to learn a bit more about it. I am facing the following problem. My table looks like this (empty fields already removed):
What i'm trying is to get a new table where "Spalte2" holds my list of ISINs and S^"Spalte 8" but also "Spalte 9" and "Spalte 10" hold my portfolio share (komma separated).
EDIT: For clarification I hope to get something like this:
EDIT: I try to get a table in here, hope it works:
| Spalte1 | Spalte2 | Spalte8 | Spalte9 | Spalte10 |
|---|---|---|---|---|
| Bâloise Holding AG | CH0012410517 | 1,04 | Null | Null |
| Barry Callebaut AG | CH0009002962 | 0,63 | Null | Null |
| Galenica AG | CH0360674466 | 0,58 | Null | Null |
| Givaudan SA | CH0010645932 | 1,24 | Null | Null |
| HelloFresh SE | DE000A161408 | 527.705,26 | 1,85 | Null |
| Kering S.A. | FR0000121485 | 431.145,00 | 1,51 | Null |
| Standard Chartered PLC | GB0004082847 | 4,610 117.699,50 | Null | 0,41 |
| Unilever PLC | GB00B10RZP78 | 42,305 315.241,76 | Null | 1,11 |
What i'm trying to get is this:
| Spalte2 | Spalte8 |
|---|---|
| CH0012410517 | 1,04 |
| CH0009002962 | 0,63 |
| CH0360674466 | 0,58 |
| CH0010645932 | 1,24 |
| DE000A161408 | 1,85 |
| FR0000121485 | 1,51 |
| GB0004082847 | 0,41 |
| GB00B10RZP78 | 1,11 |
Which way can i use in PQ to match the ISIN with its portfolio share? Thanks a lot!
Thomas
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我是正确理解您只想将每行右列的最右列的信息整合到一个列中，而无视它与第一列之间的任何其他信息？
如果是这样，那么这可能是一种可能的方法。
从一个名为Table1的示例表开始，在电源查询中：
我只是添加一个新列，然后使用如果然后语句选择最右的填充列的信息：
（在上面的M代码中，我检查每列既不是空的，也不是空白。）
我得到了此结果：
然后我选择Spalte2和自定义列，然后删除其他列以获取此信息：
Am I correct in understanding that you simply want to consolidate the information from the rightmost populated column of each row into one column, and disregard any other information between it and the first column?
If so, then this might be one possible approach.
Starting with a sample table called Table1 in power query:
I just add a new column and use if then statements to select the rightmost populated column's information:
(In the above M code, I check that each column is both not null and not blank, to be thorough.)
I get this result:
Then I select the Spalte2 and Custom columns and remove the other columns to get this:
