Dynamic search for values in dataset

[Sailor]

Hi 

I am looking for a way to search dynamically for a value and select only those rows that match. I do not want to manually select the columns that should be searched or filtered. It should be as dynamic as possible. 

I have tried with Multi-Field Formula tool and criteria REGEX_Match([_CurrentField_], 'Search value'). This gives me half of the solution. Next step is to dynamically filter the rows that match with my regex criteria and not all rows with 0 or -1.

Thanks in advance

Mats, Stockholm, Sweden

[BenMoss]

Working with your data in a wide manor will always cause difficulties, yes there are tools to negate these problems but it would be much preferable to transpose your data, then you purely have to search and filter against a single field.

After you have done all the transformations you can always cross-tab your data back prior to the output.

Ben

[jdunkerley79 · Accepted solution]

I suggest something like the following:

- Add a record ID

- Transpose it to get the fields

- Apply a filter and then group by record id to get count of passes

- Add the count to original stread (using a find and replace to avoid reordering)

- Then filter on this column

[Sailor]

Thanks a lot, the TRANSPOSE did the trick

Regards Mats

[Sailor]

Thanks, quick as always

Mats

[AbiramiJothi]

Worked great!

Thanks,

Abi