在电源查询中，复制源查询时，我也应该复制“变换文件”文件夹？
如果已经问过这个问题，我的事先表示歉意，如果是这样，我找不到它。
因此，我将这个巨大的数据库除以国家 /地区需要单独从每个国家数据库中导入的国家，然后在电源查询中将查询添加为一个。
当我导入美国文件时，电源查询会自动生成一个带有4个助手查询的转换文件夹：
然后我只是重复了疑问 - 销售并将其命名为英国 - 将其指向英国销售文件夹：
transform文件文件夹并未重复。
现在一切似乎都很好，但是我想知道这在不久的将来是否可能是问题，因为我还有几个国家要去。我应该手动将新的查询作为新连接而不仅仅是复制它们，还是无关紧要？
非常感谢！
My apologies in advance if this question has already been asked, if so I cannot find it.
So, I have this huge data base divided by country where I need to import from each country data base individually and then, in Power Query, append the queries as one.
When I imported the US files, the Power Query automatically generated a Transform File folder with 4 helper queries:
Then I just duplicated the query US - Sales and named it as UK - Sales pointing it to the UK sales folder:
The Transform File folder didn't duplicate, though.
Everything seems to be working just fine right now, however I'd like to know if this could be problem in the near future, because I still have several countries to go. Should I manually import new queries as new connections instead of just duplicating them or it just doesn't matter?
Many thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
转换助手查询是您可以编辑查询的特殊查询，但是您无法手动删除和重新创建自己的查询。它们是由PQ自动创建的，当结合内容列表时，并固有地链接到父询问。
也就是说，您不能复制它们，并且必须使用PQ提供的
组合函数来创建助手查询。但是，您可以避免复制查询，而是在父级查询中复制步骤，并使用表联合加入列表，然后再将内容与相同的辅助查询组合在一起。
The Transform Helper Queries are special queries that you may edit the queries, but you cannot delete and recreate your own manually. They are automatically created by PQ when combining list of contents and are inherently linked to the parent query.
That said, you cannot replicate them, and must use the
Combinefunction provided by PQ to create the helper queries.You may however, avoid duplicating the queries, instead replicate your steps in the parent query, and use table union to join the list before combining the contents with the same helper queries.
变换文件文件夹组包含用于转换文件列表的代码。它是可重复使用的代码。您可以看到示例文件，它是转换操作的模板。只要为
示例文件提供的文件与您要馈送到命令中的文件具有相同的结构，则可以使用任何文件中的任何查询。您需要确保的一件事是，
示例文件未从数据源中删除。您可能需要仅出于此目的创建一个新的虚拟文件，请确保不会删除其，然后将示例文件查询指向以拉动该文件。The
Transform Files Foldergroup contains the code that is called to transform a list of files. It is re-usable code. You can see theSample File, which serves as the template for the transform actions.As long as the file that is arrived at for the
Sample Filehas the same structure as the files that you are feeding into the command, then you can use any query with any list of files.One thing you need to make sure is that the
Sample Fileis not removed from your data source. You may want to create a new dummy file just for that purpose, make sure it won't be deleted, and then point theSample Filequery to pull just that file.