Forum Discussion
Solved
Approx Match 2 Sources Relationship
Hello, I have 2 data sources that i'd like to connect on UPC. One source has 10 characters while the other has an 11th (check digit). Example 1: Source A: 7430000070 Soruce B...
Hi ethanlsaul ,
Here I suggest you to add a calculated column in Source B to help relate two tables.
Approx Match = VAR _LEN = LEN('Source B'[Column1]) RETURN LEFT('Source B'[Column1],_LEN - 1)Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ethanlsaul ,
Here I suggest you to add a calculated column in Source B to help relate two tables.
Approx Match =
VAR _LEN = LEN('Source B'[Column1])
RETURN
LEFT('Source B'[Column1],_LEN - 1)
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.