excel-从电源查询中创建的外部文件创建的键值列表，编辑映射值的麻烦
我试图在从JIRA撤离的CSV列表中创建一个长列表的标准化名称列表。
到目前为止，我尝试使用的是获取数据 - ＆gt;从文件 - ＆gt;来自文件夹 然后将其缩小到我需要的列，然后删除所有重复的行。
加载后，我尝试添加只是一个空字符串的列。我在电源查询和数据模型中都具有相同的效果。我想拥有第二列，以便用户可以在工作表上的密钥列中映射值。该表将用作枢轴表标准化名称的映射。尝试更新工作表中的值，然后刷新以查看数据模型中的更改只会将值恢复回空字符串。
显然，我以错误的方式进行操作。目的是能够维护此键，在几个月内添加了新密钥，只需映射这些新条目，而不必每次比较一下，就必须进行大量工作才能查看新事物。有没有更好的方法来实现我正在尝试做的事情，并且在几个月中仍然可以维持它可以扩展，而不必重做整个工作簿？
I am attempting to create a standardized list of names for a long list of free typed values in a list of csv's pulled from Jira.
What I have tried so far has been to use Get Data -> From File -> From Folder
And then narrow it down to just the column I need and then remove all duplicate rows.
After loading that, I have tried adding a column that's just an empty string. I have done this both in power query and in the data model with the same effect. I want to have the second column so the user can map the values in the key column on a worksheet. This table will be used as a map for pivot tables to standardize names. Attempting to update the value in a worksheet and then refreshing to see that change in the data model just reverts the value back to an empty string.
Obviously i'm going about this the wrong way. The goal is to be able to maintain this key, value map over the months as new keys are added to it and just have to map those new entries rather than having to do a lot of work with comparing every time to see whats new. Is there a better way to achieve what I am trying to do and still maintain it being expandable over the months without having to redo the entire workbook?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论