The same string does not match
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have 2 columns with postcodes, that have V_WString type. When I compare them by formula below, part of them shows as don't match, but looks totaly the same (for example, '75321' and '75321' it recognizes as different). I did Trim on both columns in the previous step before the formula.
IF [recp_pstl_cd]=[Delivery/Receiver Postal Code] THEN 1 ELSE 0 ENDIF
What can be the reason?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @svergtanya,
Could you share a workflow where the issue occurs? I've tried mocking it up but my check works?
I've attached my workflow for you to download if needed.
Kind regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you able to share the offending row of data?
Try copying and pasting the values into a text editor / the Formula Tool editor as this can sometimes show up invisible control characters.
Try applying the formula,
DecomposeUnicodeForMatch(String)
to each column.
Try setting both columns to string type (not V_WString)
See if any of that works. Sharing the row of data would be the best thing though.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@svergtanya
Any chances, these two columns are having different data type, one is string, and other one is numerical?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you everyone for the help and the recommendstions.
I have found that the issue was with the logic.
The model is toooo complex and long and I didn't notice, that I have created flag for string comparison before data cleaning and transformation and it impacted the results.
Sorry for the misleading and thanks everyone for the help!
