Hi, in Pipeline builder is there a smart way (excepted IA) to populate by a 1 copy/past a long liste of values in filter transfo IS ONE OF. For the time beeing I have to write values 1 by 1.
Hey,
There’s no native copy/paste-a-list feature in the Pipeline Builder Filter “is one of” UI. But there are smart workarounds:
1: Use a “Contains” expression with a hardcoded array (for medium lists)
Pipeline Builder supports embedding expressions within transforms in one configuration form. You can use the Filter transform but swap the condition to use an array_contains or equivalent expression, passing an inline array literal — avoiding the click-per-value UI entirely.
2: Code transform (Spark/Python)
If you have access to code transforms, you can write a simple:
df.filter(F.col("my_column").isin(["val1", "val2", "val3", ...]))
Paste your full list directly from clipboard. Pipeline Builder supports users who code and users who don’t code collaborating jointly on the same pipeline.
Felipe Montes
Development Advisor
Follow me @ linkedin.com/in/felipemontesl/ or GitHub: Brazillianerd