topic Re: Identical String Values Treated As Distinct Values in App Development

Identical String Values Treated As Distinct Values

stephilippou — Thu, 19 May 2022 21:03:52 GMT

Hi,

I'm seeing an issue where two identical strings are being treated as separate values in a table. Please see the screenshot below:

I only have one column so it shouldn't be split out by any other dimensions. Furthermore, I'm already using the Trim() function to remove any leading or trailing white spaces. When I copy and paste both cell values into Notepad++ and use the Compare plugin, they're considered identical:

Has anyone else encountered this issue? Are there some non-printable characters that I might be missing? Or might this be a bug and I should open up a support case for it?

Thanks for any help or suggestions!

Stephen

Re: Identical String Values Treated As Distinct Values

Andrew_Delaney — Mon, 30 May 2022 12:42:09 GMT

That is very strange, are both lines being loaded from the same data source?

How are you loading this data?

Re: Identical String Values Treated As Distinct Values

marcus_sommer — Tue, 31 May 2022 10:18:49 GMT

To check the values definitely you may do something like this:

load
recno() as RecNo, rowno() as RowNo, iterno() as IterNo,
Field, len(Field) as FieldLength,
ord(mid(Field, iterno(), 1)) as Char
from Source while iterno() <= len(Field);

Another cause for such behaviour could be that the field isn't just a string else a dual(), because:

dual('a', 1) <> dual('a', 2)

and would lead to two 'a' values within a dimension.

- Marcus