Dynamic Field (multiple fields) input for filter

[robbertbrouwers]

Hi all,

I need to check an x amount of fields for unwanted chars such as "?" or "!". The input should be all string fields in a certain workflow:

Check Field_A for presence of unwanted chars 

Check Field_B for presence of unwanted chars 

etc.

The output only has to show me the rows where an unwanted char in any of the fields is present. 

The list of chars is limited so this could just be written in a custom filter, however I'm having difficulties with getting more than 1 field as the input on a filter tool.

Any help is greatly appreciated! 

Thanks

Robbert

[jdunkerley79 · Accepted solution]

Probably the easiest way is to do the following.

- Add a Record Id

- Use a Transpose tool with a Key field of RecordID

- You can then filter the value column

- Then use an Update tool to get the set of RecordID with an unwanted character

- Finally Join back to untransposed data on RecordID the join will give you the set of rows.

 

Sample attached

[robbertbrouwers]

Exactly what I meant, thanks jdunkerley79!