cancel
Showing results for 
Search instead for 
Did you mean: 

Using Tables in Parameter default expresion or simple constraint

Former Member
0 Kudos

Hi,

Should be straight forward, but could not get it working:

I try to use a table with standard information for  input or validation for JobChain parameters:

Goal:

1) first check if GCC (KEY) does exist in the table.

2) pre-fill parameters based on the first GCC parameter.

Table Def:

Table:

EUREURCustomerEUR_ERP_Queue284
PGSPGSCustomernamePGS_ERP_Queue280
WLZWLZ CustomernameWLZ_ERP_Queue240

Constraint for chain parameter2:

Type= Table

Data= CustomerParametersTable

result when submitting the Job:

Second problem question:

Default expression for chain parameter 3:

=Table.getColumnString('CustomerParametersTable', chainParameters.GCC, 'SystemClient')

Error mesages:

     No such identifier :: chainParameters

Trying:

     when I replace it by an hardcoded string 'WLZ'

     =Table.getColumnString('CustomerParametersTable', 'WLZ' , 'SystemClient')

    

Error:

     No such table CustomerParametersTable

1) how to use the GCC parameter?

2) Same as 1st issue, table could not be found...

  

Probably something simple, but can't find it...

Thanks!

Sjoerd

Accepted Solutions (1)

Accepted Solutions (1)

gmblom
Active Contributor
0 Kudos

Hello Sjoerd,

It looks like your table is not in the GLOBAL partition, in that case you will have to prefix your table name with the partition name everywhere.

Regards Gerben

Answers (0)