Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Dear community,

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

Capture.PNG

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Or

LOAD Company,

     [Management ID]

FROM

[community sample.xlsx]

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

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

View solution in original post

3 Replies
swuehl
MVP
MVP

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
MVP
MVP

Or

LOAD Company,

     [Management ID]

FROM

[community sample.xlsx]

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

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

Anonymous
Not applicable
Author

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