RobertIngles
Technical User
Good evening everyone!
I need to do a comparative analysis between two tables. Problem is that the fields I need to join don't match exactly. The fields are named "Barcode". The barcode in one table might be XO123456 and I need to match it to the barcode in the second table which would hold the value of simply 123456 without the leading text characters. The leading text is often different ie. XO, YG etc.
Is it possible to create a join that will match the two tables based on the last six digits?
Any and all suggestions are appreaciated!!
I need to do a comparative analysis between two tables. Problem is that the fields I need to join don't match exactly. The fields are named "Barcode". The barcode in one table might be XO123456 and I need to match it to the barcode in the second table which would hold the value of simply 123456 without the leading text characters. The leading text is often different ie. XO, YG etc.
Is it possible to create a join that will match the two tables based on the last six digits?
Any and all suggestions are appreaciated!!