How write query in "Select_analysis" that compare string from one column with another
I have a shp file (s.shp) with column "A" and column "B". I try copy from this file only that rows where string value from column "A" is part of string value from column "B" e.g.
A 0.1 0.2 0.3 B 0.12 0.21 0.43The output file should have two rows first and second.
I try make:
import arcpy source='c:\\MY\\s.shp' output='c:\\MY\\o.shp' arcpy.Select_analysis(source,output,"\"B\" like '%'||\"A\"||'%'")but I have a error
أكثر...
I have a shp file (s.shp) with column "A" and column "B". I try copy from this file only that rows where string value from column "A" is part of string value from column "B" e.g.
A 0.1 0.2 0.3 B 0.12 0.21 0.43The output file should have two rows first and second.
I try make:
import arcpy source='c:\\MY\\s.shp' output='c:\\MY\\o.shp' arcpy.Select_analysis(source,output,"\"B\" like '%'||\"A\"||'%'")but I have a error
ERROR 000358: Invalid expression "B" like '%'||"A"||'%'
I use ArcMap 10.1.
أكثر...