Need Help with Regex Match Filter on 2 fields

[pvara]

My Sample Data Set as Follows

Invoice Number	Credit Memo Number
340BVIR0000004571	12345
NOMemo	Nomemo
67657676	12346

Regex_Match ([Invoice Number], "^\d\d\d\d.*")

AND

REGEX_Match([Credit Memo Number], "^\d\d\d\d.*")

I would like to see the TRUE to look something like this.

Invoice Number	Credit Memo Number
	12345
67657676	12346

[AbhilashR · Accepted solution]

Hi @pvara, the Filter tool doesn't allow users to pick and choose the row/column combination in its output. By nature it evaluates at a row-level, and will output all columns for a given row in the TRUE or FALSE outputs.

Referring to the image below as an example (sample outputs from my workflow), the filter tool will output the two rows that meet the logic in the Filter tool, after which you will need to introduce a Formula tool to convert the alphanumeric Invoice Number (340BVIR0000004571) to null.

After Filter:

Filter + Formula:

If this isn't what you are looking for, then perhaps @grossal's solution is the only other option I can think of.