否则if prep中的语句“有效”但是数据是空白的。下面的示例
我将我的Tableau服务器连接到准备流程，一切看起来都不错！但是，一旦我想创建一个带有一个计算字段的新列（不在我的原始数据源中的列），公式显示为“有效”，但列是空白的。公式在下面，大约1000行，但我只是在这里复制并粘贴了前几行。有什么原因发生了什么事？
[应用程序
buid
如果
] =“ aldec”，然后“ al-全州”
elseif [应用程序buidse] =“ nyhor”，然后“ ny-其他”
elseif [application Building] =“ nyjam”，然后“ ny -ny-其他”
结束
I am connecting my tableau server to my prep flow, everything looks good! However, once I want to create a new column with a calc field (a column not in my original data source) the formula shows up as "Valid" but the columns are blank. The formula is below, its about 1000 rows, but i just copied and pasted the first few lines here. Any reason what is going on?
IF [Application Building] = "ALHVL" THEN "AL - Statewide"
ELSEIF [Application Building] = "ALANN" THEN "AL - Statewide"
ELSEIF [Application Building] = "ALBIR" THEN "AL - Statewide"
ELSEIF [Application Building] = "ALDEC" THEN "AL - Statewide"
ELSEIF [Application Building] = "NYHOR" THEN "NY - Other"
ELSEIF [Application Building] = "NYJAM" THEN "NY - Other"
END
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从上面的观测值中，我们可以说这是由于前导或落后空间所致，我们可以使用装饰函数消除。仍然有问题，共享示例数据以获取更多详细信息。
From above observation we can say it's due to leading or trailing spaces, we can eliminate by using TRIM function. Still have the issue, share a sample data to get into more details.