Skip to main content
added 69 characters in body
Source Link

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.

 Ar

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?

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.

 Ar

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.

Do you think that an SQL query is the correct approach?

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.

 Ar

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?

deleted 26 characters in body; edited tags
Source Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345

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.

 Ar

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. 

Do you think that an SQL query is the correct approach? Recommend another solution?

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.

 Ar

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. Do you think that an SQL query is the correct approach? Recommend another solution?

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.

 Ar

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. 

Do you think that an SQL query is the correct approach?

removed thanks
Source Link
Vince
  • 20.3k
  • 16
  • 48
  • 65

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.

 Ar

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. Do you think that an SQL query is the correct approach? Recommend another solution? Thank you.

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.

 Ar

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. Do you think that an SQL query is the correct approach? Recommend another solution? Thank you.

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.

 Ar

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. Do you think that an SQL query is the correct approach? Recommend another solution?

Source Link
Loading