Forum Discussion

binux's avatar
binux
New Member
7 years ago
Solved

Equal values handled as separate values inside report

Hi everyone,   I came across a strange issue. I have two tables which contain information about mobile devices and their hardware capabilites. They both have the same column identifiers, but origin...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    binux may be there is special character (non printable) in one of the value, in query editor, you can use clean and trim your column after append and see if that fixes it.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

binux may be there is special character (non printable) in one of the value, in query editor, you can use clean and trim your column after append and see if that fixes it.

binux's avatar
binux
New Member
7 years ago
parry2k wrote:

binuxmay be there is special character (non printable) in one of the value, in query editor, you can use clean and trim your column after append and see if that fixes it.

I did clean it without any effect. However "Trim" was removing a leading space which apparently was the issue. Thanks for your help!