Question

WorkspaceRunner with SQL Statement

  • 9 April 2018
  • 1 reply
  • 2 views
D

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.

1 reply

takashi
Rank
Userlevel 2
Badge +17

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

28,670
Posts
109,367
Replies
36,531
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.