我正在尝试在Spotfire中创建计算列,在该列中,在分配新值之前,必须在另一个表的列中显示特定值。
I'm trying to make a calculated column in Spotfire, where a specific value has to be present in a column of another table before a new value is assigned.
我的表情如下:
If(Find('Specific value first table',**'present in second table'**) is Null, 0, 'New Value')我不知道如何在搜索中包含第二张表,有人知道吗?
I have no idea how to involve this second table in my search, does anyone has any idea?
谢谢!
推荐答案您将无法在创建计算列时引用另一个表。但是,我认为我们可以完全解决您的问题。
You won't be able to reference another table when creating a calculated column. However, I think we can solve your problem all the same.
您想要做的是尝试通过加入包含您的值的列来插入其他表中的列正在搜索,然后使用简单的计算列检查它是否存在。您需要将空值设置为新值,并保留现有值。类似于的情况,当[new_column]为null则为'new_value',否则[new_column]结尾。
What you'll want to do is attempt to insert columns from your other table by joining on the column that holds the values you're searching for and then check if it exists with a simple calculated column. In your case you'll want to set the null values as your new value and keep the existing values. Something like case when [new_column] is null then 'new_value' else [new_column] end.
以下是先前的类似内容,但略有不同为方便起见,我用下面的答案回答了另一个问题。
Below is a previous similar but slightly different question I answered with my answer copied below for convenience.
如何搜索Table1列的值在Spotfire中是否存在于Table2列中?
我的数据和上面后面的结果列:
My data and resulting columns after the above:
您现在应该能够根据新列进行过滤和计算)。
You should now be able to filter and do calculations based on your new column(s).
更多推荐
spotfire:搜索另一个表的列
发布评论