Conditional Column based on Text.Contains gives sporadic error

[Alicia_Anderson]

I have 2 columns defined as Text (Reported in Release & Support Version).   I replaced all nulls in each column.   I have logic to use either the value from the first column or the 2nd column field to create the new column (Rep Release/Version).   This part works fine.   

Next I want to create another conditional column based on the results of the new column.   First I added a step to ensure the new column (Rep Release/Version) was defined as Text.  I am using Text.Contains logic to determine value for new field.   

I am getting the error "We cannot convert the value null to type Logical" for only a percentage of values.  This makes no sense because there is no null value.  Please help.  

[Alicia_Anderson · Accepted solution]

I finally figured out the problem.  There was an additional field that I used in the conditional column (which was not included in my screenshot).   That field still had some null values.   

[v-stephen-msft]

Hi @Alicia_Anderson ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[PhilipTreacy]

Hi @Alicia_Anderson 

It's hard to debug this without the source data and your query code - can you supply them?

You say First I added a step to ensure the new column (Rep Release/Version) was defined as Text - is this working for all rows?  How did you implement this?

Regards

Phil