Hello all,

I am attempting to create a published parameter within a custom transformer that prompts the user to state which is the primary key field from the input database table.

Is there a way of creating this published parameter, whereby it provides the user with a list of all available feature attributes (i.e. database fields) from their input table, so that they can select which is to be nominated as the primary key?

##Update, it looks like I have managed to answer my own question - you can use the Type: AttributeList within the the published parameter to achieve this

As a follow up question, does anyone know how I can then use the user chosen parameters within a stringreplacer transformer to update a field?

Basically, using the data example below, if the user, via published parameters, the user has nominated colA as their primary key field, and nominated colB via another published parameter, is there a way of then using the values within these fields to then replace colA as a concatenation of the two field values?

From this:

To this:

I have tried using the StringReplacer as per below but it is writing out as blank

Thanks in advance,

RB