Creating a ValueTable with a column that has dependency

Question

I am creating a python tool which looks like the figure below.

Input feature: It asks for a input feature class. Valuetable(Lookup tables): It has two columns - one for look up tables and another for fields.

The fields in value table should have dependency on Input feature. is this possible ? How ?

Code:

 def getParameterInfo(self):
    param1 = arcpy.Parameter(
        displayName = "Input Feature",
        name = "in_features",
        datatype = "DEFeatureClass",
        parameterType = "Required",
        direction= "Input")
    param1.filter.list = ["Polyline"]

    param2 = arcpy.Parameter(
        displayName='Lookup tables',
        name='lookup',
        datatype='GPValueTable',
        parameterType='Required',
        direction='Input')

    param2.columns = [ ['DETable', 'LookupTable'], ['Field', 'Fields']]


    param2.filters[1].type="ValueList"  
    desc = arcpy.Describe(param1)  
    fields = desc.fields
    l=[]
    for f in fields:
        l.append(f.name)
    param2.filters[1].list = l

    param3 = arcpy.Parameter(
        displayName='Output',
        name='excel',
        datatype='DEFile',
        parameterType='Required',
        direction='Output')
    param3.filter.list = ['xls', 'xlsx']



    params = [param1, param2, param3]
    return params

Typically, you would set parameter dependencies like this: param2.parameterDependencies = [param1.name]. But it sounds like you want the user to add a table into the Value Table as a "Lookup Table", and then choose a field from that? Is that what you mean? — crmackey, Aug 21 '15 at 15:57
Someone can correct me if I'm wrong here, but if this what you are wanting to do, I don't think it's possible to set a filter on the Field column of your value table based on the Lookup Table value in that same row in a PYT. You might be able to customize this in .NET, but I'm not sure. It would be awesome though if Esri implemented an advanced filter option where you could dynamically change filters in each row of the Value Table. — crmackey, Aug 21 '15 at 16:10
No. let me correct you. The field in valueTable has dependency on the Input feature class and not lookup tables. — Jio, Aug 21 '15 at 18:41
I added some more code after param2 definition though it doesnot work. — Jio, Aug 21 '15 at 18:57
Haha, ok. I was able to get it to work, but I think in order to use parameter dependencies you have to have the Fields as the first column in the Value Table. Se my answer below. — crmackey, Aug 21 '15 at 19:18

score 1 · Answer 1 · answered Aug 21 '15 at 19:16

I think you need to have the Fields as the first column in the Value Table in order to use the parameter dependency:

import arcpy
import pythonaddins

class Toolbox(object):
    def __init__(self):
        """Define the toolbox (the name of the toolbox is the name of the
        .pyt file)."""
        self.label = "Toolbox"
        self.alias = ""

        # List of tool classes associated with this toolbox
        self.tools = [SomeTool]

class SomeTool(object):
    def __init__(self):
        """Define the tool (tool name is the name of the class)."""
        self.label = "Set up Variables"
        self.description = ""
        self.canRunInBackground = False

    def getParameterInfo(self):
        param1 = arcpy.Parameter(
            displayName = "Input Feature",
            name = "in_features",
            datatype = "DEFeatureClass",
            parameterType = "Required",
            direction= "Input")
        param1.filter.list = ["Polyline"]

        param2 = arcpy.Parameter(
            displayName='Lookup tables',
            name='lookup',
            datatype='GPValueTable',
            parameterType='Required',
            direction='Input')

        param2.columns = [ ['Field', 'Fields'], ['DETable', 'LookupTable']]


        param3 = arcpy.Parameter(
            displayName='Output',
            name='excel',
            datatype='DEFile',
            parameterType='Required',
            direction='Output')
        param3.filter.list = ['xls', 'xlsx']
        param2.parameterDependencies = [param1.name]

        params = [param1, param2, param3]
        return params

    def isLicensed(self):
        """Set whether tool is licensed to execute."""
        return True

    def updateParameters(self, parameters):
        """Modify the values and properties of parameters before internal
        validation is performed.  This method is called whenever a parameter
        has been changed."""

        return

    def updateMessages(self, parameters):
        """Modify the messages created by internal validation for each tool
        parameter.  This method is called after internal validation."""
        return

    def execute(self, parameters, messages):
        """The source code of the tool."""
        arcpy.AddMessage('Success')   
        return

Yes. by putting in first column it is possible but then how can i select the lookup tables interactively ? I think in your example you wrote the names "foo" and "bar" . You did not select them from file system . isnt it ? — Jio, Aug 21 '15 at 19:35
I just typed those in. These value tables seem kind of limited on what you can do. I have been tinkering with it and cannot seem to get more than one drop down to work. I thought I would be able to do nested lists in the UpdateParameters method, something like parameters[2].filter.list = [[fieldList, lookupTable] for fieldList, lookupTable in valuetable] but this didn't work either. It may not be possible in a PYT. — crmackey, Aug 21 '15 at 19:59

Creating a ValueTable with a column that has dependency

1 Answers1

Linked