I have columns that are in the same format and I want to extract the same text from all of these columns, instead of using multiple regex extractors to do this, I’m willing to use one regex extractor and input multiple columns as we usually do in string manipulation(multiple) node. But I am stuck in inputting multiple columns, I tried this way, Can someone help me here? See my workflow.
You could use the Column List Loop to cycle through the Regex Extractor and select the target column by flow variable. “Included” column names will be the columns you want to pass one by one through the Regex Extractor (and select by flow variable). “Excluded” will be the ones that are always in each iteration. You can filter to the target Column Name for each iteration by removing all “Excluded” column names.
You might even be able to skip flow variables all together if you use a Column Splitter first to separate your “Included” columns so the are the only ones looping through the Regex Extractor, then append the other columns back after you close the loop.
Thanks for the guide, it works.
Glad to hear it. Welcome to the forum by the way! Please mark the post as the solution with the when you get around to it. It helps point future user’s searches toward correct answers to their questions, and helps forum admins to avoid questions slipping through the cracks and going unanswered.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.