Row-Filterning | ZIP-Code

[USCHUKN1ME]

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

[Andrew_Steel]

Hi @USCHUKN1ME,

you could use a Nominal Row Filter Widget:

Transfer your first ZIP Code digit into nominal value:

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

I hope this will solve your problem.

Best Regards
Andrew

[USCHUKN1ME]

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

[Andrew_Steel]

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

[USCHUKN1ME]

KAP = KNIME APPLICATION INSTALLATION?

[Andrew_Steel]

Sorry,

KAP = KNIME Analytics Platform

[USCHUKN1ME]

Np @Andrew_Steel

Problem with the KAP solved!

THANK YOU!!

Greetings