Forum Discussion
Merge query returns no matching values when there are matching ID columns
I am working with some tables from Salesforce, and it requires merging queries to relate different objects. I was able to create a Parent Case / Child Case relationship by merging queries successfull...
vanessafvg
Community Champion
Community Championare the id's numbers or text? is it possible to share an example of some of the data that you trying to match?
Thank you for the reply! I actually figured it out when I was gathering some sample data for you to reivew.
It looks like Salesforce was appending a few extra digits to the Parent Case Table ID, that are not always present in the Data Tracker table.
5008a000027GPig
5008a000027GPigAAG
5008a00001uVEPw
It seems like if I delete the 3 extra digits (15 digit ones work and 18 digit ones don't), I can get a result, so I am thinking, if I do a custom column to remove the last three digits but only if the character length = 18.