Forum Discussion
Anonymous
6 years agoNot applicable
Expression.Error: We cannot convert the value null to type Logical. Details: Value= Type=[Ty
Hi everyone, I am sure we've all seen this error before. My example however, simply doesn't make sense. I have a simple if lengthy Conditional Column. I am compiling a "friendly" Customer na...
Jimmy801
6 years agoCommunity Champion
Hello Anonymous
question... why you don't rename these columns prior of combining them?
And afterwards use a 2nd table to join the friendly name to it?
Jimmy
- Anonymous6 years agoNot applicable
Becuase which column contains the information I need to determine the Customer Name varies, I can't just stack them in one query.
What I did in the end was build the Conditional Column in each of the smaller queries before apending.
That worked fine, even thoguh some of the these CC's were preteyy complex and lengthy I dind't have any problems
I still am not sure why I was getting that error though.