Skip to main content
  • EN

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.

Hi @dmasl, it seems to be a known issue which has not been resolved yet, but possibly you could avoid the issue by changing type of the parameter to 'Text (Multiline)'. See also these threads.

Reply


Community Stats

30,469
Posts
115,712
Replies
38,288
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.