topic Betreff: Need Help with Regex Match Filter on 2 fields in Alteryx Designer Desktop Discussions

Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 19:05:17 GMT

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

Re: Need Help with Regex Match Filter on 2 fields

MarqueeCrew — Mon, 04 May 2020 19:22:05 GMT

Hi @pvara ,

Please start with a filter containing this formulae:

// Credit memo is 4 or more digits REGEX_Match([Credit Memo Number], "\s*\d{5.}\s") // Added allowance for spaces \s* because your data has them AND // Invoice Number contains 4 or more digits Regex_match([Invoice Number ], ".*\d{4,}.*")

Let's see if it gets you the TRUE records that you're after.

Cheers,

Mark

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 19:27:03 GMT

Hi @pvara,

I think you should go with a Multi-Field-Formula and a Filter for this:

Result:

Settings:

The formula is basically the same as yours.

Workflow sample attached. Let me know what you think.

Best

Alex

Re: Need Help with Regex Match Filter on 2 fields

AbhilashR — Mon, 04 May 2020 19:46:35 GMT

Hi @pvara, I started putting something together as a solution but I now see being late to the party. Sharing it here as another response just to put it out there. But please credit others if their solutions work for you.

Betreff: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 20:05:52 GMT

HI Alex,

I am warming up to your solution, however, I would like to see the False as an output, I plan to do further downstream processing.

Any thoughts?

Re: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 20:07:09 GMT

Hi Mark

The regex expression does not work, I am getting all FALSE results.

Re: Need Help with Regex Match Filter on 2 fields

MarqueeCrew — Mon, 04 May 2020 20:10:40 GMT

I tested with your sample data. Can you add a csv of more data?

Thanks?

mark

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 20:25:53 GMT

If you want to have both in one stream, than just remove the filter. If you want to treat them differently, than use the F-Anker from the Filter Tool to process the False outputs.

Another option would be to enable "Copy Output to new Fields and Add"

The output would look like this:

I'll attach an updated sample workflow for you. Let me know what you think.

Best

Alex

Re: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 20:57:28 GMT

here is a csv with some data

Betreff: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 21:16:20 GMT

maybe I am missing something, how would I use the filter tool to process the False results?

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 21:21:31 GMT

You could do something like this:

This allows you to treat the bad data differently than the good data. Workflow sample attached.

Best

Alex

Betreff: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 21:48:17 GMT

Hi Alex,

I like your approach however, I was expecting to 2 records for the FALSE for Invoice Number.

Any thoughts?

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 23:03:27 GMT

I think your original Input showed this:

Therefore I changed the Filter condition from your original AND (that didn't not match your provided data sample) to an OR. If we switch the condition we get two bad and one good:

Updated workflow attached. Is this what you want?

Best

Alex

Re: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 22:58:57 GMT

Hi @AbhilashR

When reviewing your REGEX_Match Expression

Regex_match([Invoice Number], ".*\d{4,}.*")
AND
REGEX_Match([Credit Memo Number], "[0-9].*")

It did not catch this value for Invoice Number

340BVIR0000004571

If we can catch this value then we will be solid.

Thank you

Betreff: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 23:02:11 GMT

Hi @grossal

i believe you attached the incorrect workflow.

Re: Need Help with Regex Match Filter on 2 fields

AbhilashR — Mon, 04 May 2020 23:03:03 GMT

Hi @pvara, the output of my workflow matches the original output you were looking to create. What should the output of the workflow be?

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 23:05:03 GMT

I fixed the attachment @pvara. Take another look 😃

Re: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 23:08:06 GMT

Hi @AbhilashR

What is in the red box should show up in the false in the filter

The non red boxed should be in the true.

Betreff: Need Help with Regex Match Filter on 2 fields

pvara — Mon, 04 May 2020 23:12:25 GMT

Hi @grossal

can you please reattach the file?

Betreff: Need Help with Regex Match Filter on 2 fields

grossal — Mon, 04 May 2020 23:17:44 GMT

Here it is 😃