Link tables through part of field into script

[#1]

I need to join some tables in QV where I have the article codes and sales for each of them.

The last loaded table is different and provides me with a key to organize the different articles.

LOAD

Code,

Type

FROM

(ooxml, embedded labels, table is Foglio1);

Code should be linked to the last two letters of 'Article' already loaded in previous tables.

If I try to write

Load

Code as right(Article,2),

it does not work...

Any advice?

Thankx

[awhitfield]

Hi Massimo,

add this Right(Article, 2) As Code to the previous table that loads the article NOT the

LOAD

Code,

Type

FROM

(ooxml, embedded labels, table is Foglio1);

eg

DATA:
LOAD Article,
Right(Article, 2) As Code

FROM

(ooxml, embedded labels, table is Sheet1);

HTH

Andy