Column Expression and Missing Values

KNIME Extensions
1

Hello all,

I’m having an issue with the column expressions node and the following logic:

if(column("Delivery TLD") == missingValue())
    {"N/A"}
    else if(column("Subdomains") == missingValue() && column("First SubDirectory")==missingValue() && column("Second SubDirectory")==missingValue())
        {column("Delivery TLD")}
    else if(column("First SubDirectory") == missingValue() && column("Second SubDirectory") == missingValue() && column("Subdomains")!= missingValue())
        {join(column("Subdomains"),".",column("Delivery TLD"),"/")}
    else if(column("Second SubDirectory")==missingValue() && column("First SubDirectory")!=missingValue() && column("Subdomains") != missingValue())
        {join(column("Subdomains"),".",column("Delivery TLD"),"/",column("First SubDirectory"),"/")}
    else (column("Subdomains") != missingValue() && column("First SubDirectory") !=missingValue() &&column("Second SubDirectory")!=missingValue())
        {join(column("Subdomains"),column("Delivery TLD"),"/",column("First SubDirectory"),"/",column("Second SubDirectory"),"/")}

I’m not sure why but only the last else statement works, resulting in domains being .example.com/1st/2nd/ or worse: .example.com///

Any insights on how to properly work this logic to account for the missing values?

2

You need to use function IsMissing() not a missing value.

3 Likes
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.