Only keeping certain values by comparing with another field (wildmatch?)

[Anonymous]

Dear community,

I have two fields in a table with some garbage that I don't want to include.

I only want to keep the values from column B that are similar to those of column A.

So 120058 should be linked to 120058-01, 120058-02 and so on.

All of the other values from column B should be excluded from the load.

I will attach the excel file.

Also note that column A also contains cells with 3 oder 4 numbers instead of 6.

The values that I need are identical, except for the last 3 characters/digits of the string.

Does anyone know how to do this?

Thanks in advance!

Best regards,

Mats

[swuehl]

Maybe something like

LOAD Company,

     [Management ID]

FROM

[community sample.xlsx]

(ooxml, embedded labels, table is [KonsEinheiten-Kombi])

WHERE Left( [Management ID],Len([Management ID])-3)=Company;

[swuehl · Accepted solution]

Or

LOAD Company,

     [Management ID]

FROM

[community sample.xlsx]

(ooxml, embedded labels, table is [KonsEinheiten-Kombi])

WHERE Wildmatch([Management ID],[Company]&'???');

[Anonymous]

Works like a charm. Thanks for the quick and helpful response!