Ticket #29685
CONCAT Calc field not working for two fields in my application. It is working for the others however. What is the problem?
Without looking at the data I can't be certain, but from what you are describing it sounds to me like if the CONCAT function works with some fields, but doesn't work with others, it's likely the field values (or lack thereof) that is causing the function to not work as you'd expect. For instance, if you are trying to CONCAT two fields and they are both NULL, this result of the CONCAT function will also be NULL. I would examine the data to see if each field you are trying to concatenate has valid data.
Asked on November 12, 2019