Icon

0042多种条件匹配查询

拜访表
Table Creator
Row to Column Names
replace($业务员$, "，", ",")
String Manipulation
replace($业务员$, "，", ",")
String Manipulation
Cell Splitter
Ungroup
GroupBy
查询表
Table Creator
Cell Splitter
Ungroup
Sorter
Missing Value
Constant Value Column Appender
Joiner
GroupBy
Row to Column Names
查询表
Table Creator
拜访表
Table Creator
Value Lookup
方法1 构造正则
String Manipulation
String Manipulation
Row to Column Names
Row to Column Names
indexOf($业务员_SplitResultList$,$业务员$ )
String Manipulation
Joiner
Rule Engine
$业务员_SplitResultList$ MATCHES $正则$ => "已拜访"
Rule Engine
if (contains(column("业务员_SplitResultList"), column("业务员"))){ "已拜访"}else{ "未拜访"}
Column Expressions (legacy)
查询表
Table Creator
Row to Column Names
regexMatcher($业务员_SplitResultList$, ".*"+$业务员$+".*")
String Manipulation
拜访表
Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: su
Created at: 2026-03-03
On NodePit since: 2026-03-05
Last update: 2026-03-05
Created with KNIME version: v5.8.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!