topic Re: Only keeping certain values by comparing with another field (wildmatch?) in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sat, 01 Apr 2017 11:18:23 GMT

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 — Sat, 01 Apr 2017 11:20:28 GMT

LOAD Company,

[Management ID]

FROM

[community sample.xlsx]

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

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

Anonymous — Sat, 01 Apr 2017 15:34:05 GMT

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