Hi, I have a large dataset with many different column names. I want to have an if statement that filters for all columns. For example, I have a table: row_number Name1 Name2 Name3 Name4 Name5 1 3 4 9 1 XXX 2 7 XXX 2 9 5 3 2 2 2 8 6 4 7 2 1 XXX 3 5 10 9 3 5 2 I want the output to be rows with the value XXX in it. row_number Name1 Name2 Name3 Name4 Name5 1 3 4 9 1 XXX 2 7 XXX 2 9 5 4 7 2 1 XXX 3 My table name is not uniform like that (not like 1,2,3,4...). They are just english words. Thank you.
... View more