I'm trying to perform an SQL query in ArcMap with the following data set, and I have not been able to solve the problem.
The idea is to keep all the information of the columns, but for example if the column "sens" has the value "S1" discard the value "S2_adjusted" that has a value of "NaN" but leave the column "S1_Adjusted". The same process for the data with value "S2" in the "sens" column, that is, leave only the value of "S2_adjusted" and discard "S1_adjusted". Without losing information in other columns.
I am using Arcmap 10.6.1 and the data comes from an Excel file.
Do you think that an SQL query is the correct approach?