Row-Filterning | ZIP-Code

Hello,
I’m sure this filtering is faster and easier, but I can’t find the right node / workflow for it.

It is about filtering the ZIP code of a customer address database for output in the map viewer node. of a customer address database for output in the map viewer node.

I test some Nodes like interactive Value Filter Widget and the Interactive Range Slider Filter Widget
but neither of them solve the problem.

Anyone have an idea?

Greetings

Hi @USCHUKN1ME,

you could use a Nominal Row Filter Widget:

Bildschirmfoto von 2021-03-08 22-01-48

Transfer your first ZIP Code digit into nominal value:

Bildschirmfoto von 2021-03-08 21-58-02
Bildschirmfoto von 2021-03-08 21-58-16

and filter this nominal value with Nominal Row Filter Widget node:

Bildschirmfoto von 2021-03-08 21-59-22

I hope this will solve your problem.

Best Regards
Andrew

1 Like

Hello @Andrew_Steel ,

Thanks for the quick reply.

New workflow with the Nominal Row Filter Widget Node:

It works, but i get this Error-Message:

Greetings

Hello @USCHUKN1ME,

first, I have noticed that your ZIP data is string based. If so, the strings can of course be processed directly. With the String Manipulation node and the entry substr($ZIP$, 0,1) the required nominal value can be generated.

Second, it looks like a problem with your KAP installation.

Best regards
Andrew

1 Like

:+1:

KAP = KNIME APPLICATION INSTALLATION?

Sorry,

KAP = KNIME Analytics Platform

Np @Andrew_Steel :slightly_smiling_face:

Problem with the KAP solved!

THANK YOU!!

Greetings

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.