Filtering Data in Multiple Columns

[cchueh]

Hello,

I currently have the below output for Test 1 -3 as output from the filter I have integrated in the second screenshot. 

Test 1 is to indicate "review" if the last column file attached is blank.

Test 2 is to indicate "review" if the short text column is blank with no content.

Test 3 is to indicate "review" if the short text column does not include a valid license plate. 

However, I cannot seem to merge the filters to have the output I want as per below, for example if Test 1 is indicated as review, however the workflow will still go through test 2 and test 3 and indicate if it should have "review". In the first row, there is no file attached in the last column nor short text in the second last column, therefore Test 1 to 3 should all have "Review", but right now only Test 2 - 3 have "Review".

*Red fonts "Review" are the outputs I want in addition to the first screenshot. 

[Qiu · Accepted solution]

@cchueh 

You are doing the way I usually not.

Just one question is that how do define a valid License Plate?

In my sample I assume it should a format AAA-1234.

If you could more data sample, I sure can calibrate the workflow more accurately.

[cchueh]

@Qiu 

Thank you for the quick response.

Unfortunately I do not have more data sample, however any format in AAA-1231 or AAA 1234 or AAA1234 can be filtered out!

[Qiu]

@cchueh 
In that case, we will just need to change the Reg Match part to below.
If you find it useful, appreciate you would mark it as useful.

\w{3}.*\d{4}

[cchueh]

@Qiu

Thank you so much!!