Use inline variable for a field name in Select Layer by Attribute ----HELP!!!!

HussainMalik1

Hi, 

@XanderBakker , @DavidPike , @SMehta 

How can I use an Inline Variable as a field name in Select Layer by Attribute in code block.  

I want to get the field name from multivalued variable table rather than from Attribute Table.  In Select Layer by Attribute   Year and %VariableFieldName%  value in "where clause" comes from string Var2 as shown in the Image.

 

def x(Var2):
    for i in Var2.split(";"):
        a,b=shlex.split(i)
        with arcpy.EnvManager(scratchWorkspace=r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb", workspace=r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb"):
lyr = arcpy.management.SelectLayerByAttribute(r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb\IDEAL_SHAPE_TimeSeries_Feb14_V1", "NEW_SELECTION", f"Year = {a} And %VariableFieldName% >0, None)

Data type : 
Long

 

 

I will really appreciate your help

Thanks 

CodeBlock.JPG

HussainMalik1

So I have changed the SelectLayerByAttribute and put the values (a and b) from string VT1  in curly brackets. where {a} = Year field and {b} = !ELECUSE_Large_Schools! field in attribute table. 

Code below is a snippet from model builder Python in Arcpro. 

Now this runs with no error message but it only selects the last part of the  VT1 string. 

How can i make it run for the whole VT1 variable?   

import shlex
s_ws = r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb"
ws = r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb"
tbl= "IDEAL_SHAPE_TimeSeries_Feb14_V1"
def x(VT1):
    for i in VT1.split(";"):
        a,b,c= shlex.split(i)
        with arcpy.EnvManager(scratchWorkspace=s_ws, workspace=ws):
            lyr= arcpy.management.SelectLayerByAttribute(tbl, "NEW_SELECTION", f'"Year" = {a} and "{b}">0'.format(a,b),None)
            x= arcpy.management.GetCount(lyr)

def Model5(VT1=[[2020, "ELECUSE_Large_Schools", 0.2], [2040, "ELECUSE_Large_Schools", 0]]):  # Model 4

    # To allow overwriting outputs change overwriteOutput option to True.
    arcpy.env.overwriteOutput = False


    # Process: Calculate Value (Calculate Value) ()
    if VT1:
        Value = x("VT1")

if __name__ == '__main__':
    # Global Environment settings
    with arcpy.EnvManager(scratchWorkspace=r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb", workspace=r"D:\GBT_R_Drive\GBT_GIS\ICEMIgdb\ICEM\BldgEmission.gdb"):
        Model5(*argv[1:])

 Thanks