topic Join fields with different length in Connectivity & Data Prep

Join fields with different length

MichaelFL — Tue, 17 Dec 2019 08:43:24 GMT

Hello, i would like to join two field (materialno) .

The first loaded table has values with 12345,23456 and the second table has 000000000000012345 or 000000000009012345

Table 1 5-digit

Table 2 18-digit.

How can I change it ? Many thanks in advance.

DavidM — Tue, 17 Dec 2019 08:50:08 GMT

If the identifier in the second field is always last five numbers you can do it like this:

Right(Field2,5) as Field2

Make sure that both fields have the same name when joining

MichaelFL — Tue, 17 Dec 2019 08:51:58 GMT

Thank you for fast answer.

How to do this when the second table has also values with 8 digit?

DavidM — Tue, 17 Dec 2019 08:53:45 GMT

If the identifier is always 5 digits it doesn't matter. The function always takes last 5 numbers

MichaelFL — Tue, 17 Dec 2019 09:07:30 GMT

now I understand Thanks 🙂