Hi there,
I'm trying to process an SQL statement for reading a ESRI filegeodb.
I want to concatinate the statement in my first workbench and then give it to my second workbench via the WorkspaceRunner.
- The first workbench aggregates distributors attributive with a seperator ",". So at the end there is for example a string '0781A21','0761A1'
- My workbench2 should dissolves areas based on the distributors. My Reader where clause is actually: DISTRIBUTOR IN ('$(concat)') tried also DISTRIBUTOR IN ($(concat))
$(concat) is the published parameter containing the statement.
As an example the SQL statement I want to process in the reader of workbench2 should look like: DISTRIBUTOR IN ('0781A21','0761A1')
How do I need to definine the statement in workbench1. The workbench2 is actually only processing the first distributor but not the second,third... translation log is --concat '0781A21' --'0761A1'
Can find my mistake so I need your help.
