Load left of an excel field

[sibrulotte]

Hi,

I'm trying to load two tables, and I'd like the two to link on a specific field that is not presented in the same way.

ie:

Table 1, [supplyer]  is showed as : 123456

Table 2, [supplyer] is showed as : 123456 - Staples and posters Inc.

How can I load these two tables and have them link on the first 6 charaters of [Supplyer] of table 2, and the whole field [Supplyer] of table one.

Thanks!

btw, if you are having a go with my qvw, the fields are [Identification] and [Code Référence] which was not loaded in that qvw, sorry.

[calvindk]

Table 1:

Load supplyer as supplier_id

Resident YourTable;

Table2:

Load supplyer, left(supplyer, 6) as supplier_id

Resident YourTable2;