Match a string value across multiple column and return the result in new field

[Kishore_MJ]

I have a data set with multiple columns. I have to match a string with the columns and return that value in new field if available

Example

Fields1	Fields2	Fields3	field 4
Platform 1	Platform 2	Platform 3
	Platform 2	Platform 3
Platform 1	Platform 2
platform 1

Expected

Field 4  I should get

1.  platform 1

2. PALFORM 2

3. BOTH

4.OTHERS

[apathetichell]

I think you missed part of your input here. I see data. I see output. I don't think I see a match matrix????

Recordid - transpose. join on record id of match vs match and value/value -> filter -> summarize tool group by recordid concat your values -> join by recordid back to your original data.

that's the usual way to do this.