Missing 'DOT' / Period character in item list

[davyqliks]

I am building a dash board from multiple QVD's

I have an issue where an item name is losing a suffixed "." Dot.

In the image attached you can see in one load CHZ, the items does not have this character on the item but in CYY the same item does have the DOT

When i concatenate the data i am finding no records are missing but for the CYY the . is missing from the item name.

Does anyone know of any strange handling of data when it comes to this "." in a name for use in QV?

I have checked the source data and there is no time when the Invoice number does not have the . in the item

I do have values in the Dashboard with items having a . but there is no value without the . from any source.

Any help/explanation would be much appreciated.

Thanks

Daniel

[m_woolf · Accepted solution]

Try loading the Item No field as text:

text([Item No.] as [Item No.]

[davyqliks]

Thanks for the reply,

I will give this a go and let you know how it goes.

Regards,

Daniel

[davyqliks]

Thank you so much for taking the time to assist. this worked perfectly to get me both values in the merged data load.

Regards,

Daniel