Question

我在电线上有一个表格,从一些Excel文档中输入,而这一数据是我所掌握并确实在计算栏上运作的其他数据表,然后在电纸数据模型上添加一些纸板,最初,在我通过删除或增加更多的栏目和编辑内部加入业务来调整电站表之前,所有工作都非常顺利,现在,我与我一起更新,希望通过电线表来显示电线模型,因此我没有错误,表格就没有出现。

我如何纠正这一错误?

我的英文职业介绍

Answer 1

Yes, often when changes are made to initial queries these issues happen. Normally, when Query Names and/or Field/Column Names are changed and these names are used in the Merge or calculation steps query will pop these errors. So, review/compare all the changes that you made to steps after the merge. If you don t find any errors, consider making a copy of the steps and rebuilt from the merge to ensure optimum performance.

Answer 2

I think it depends on the structure of your code, if you "hard code" the steps, whenever you remove, but especially add columns, it gives you an error. You need dynamic columns. I suggest you watching this video. It might gives you some idea about the structure of the code. https://www.youtube.com/watch?v=Z3r9JbW9QUs&list=PL5NlUYOM2iOgYQCf0HJlwKnsXvun40YIm&index=12

Answer 3

Alex here

问题似乎是由于你的数据集的形成而可能出现重复的主要价值。我的建议是,把主要关键一栏选入权力库,从你选择的DIM(分裂)表格中删除重复。

这方面的一个例子是:

Let s say you have two tables, one containing transactional data with events per country and another with a DIM (dimension) table of countries with unique values for each step.

Transactional table ("TransactionTable"): | EventID | Country | EventValue | |---------|---------|------------| | 1 | USA | 100 | | 2 | Canada | 150 | | 3 | USA | 120 |

DIM table ("CountryDIM"): | Country | Region | Population | |---------|-----------|------------| | USA | North | 330 | | Canada | North | 38 |

假设“国家”是你的主要关键,就是要把权力授予,在“国家”表中选择“国家”一栏,并删除重复,以确保独一无二。

在您的设想中,这一进程有助于避免与重复主要价值相关的潜在问题,从而更新电波模型。确保主要钥匙保持独一无二的特点,防止更新过程中出现错误。

我希望这一指导有助于解决你再次经历的问题。如果你有进一步的问题或需要更多的援助,就感到可以自由要求。亲爱!

友情链接