I have a column in my database that is being registered as a string because it’s a number prefixed with a character. I’m trying to do a join with this table, but can’t because of the character. Is there any way to make this join work? For example I would like to join “e5678” to “5678”.
Hey Zachary!
Yes, this is possible with Calculated Joins! For this example you can use a formula on the join key to make sure they match – I believe this formula will work out for you.
Right(Text([column]),4)