DBInput Table, v. 3.1 - how to refer to input port in SQL

CloverDX Platform
1

In a DBInputTable I would like to refer to the data being passed via the IN port.

Scenario:
In DBInputTable0 I am querying to obtain a varchar(10) string, then outputting it to DBInputTable1 (to DBInputTable1 input port).

In DBInputTable1 I would like to use that string in the SQL statement. How?

Many thanks for your help!

2

Hello,
probably the easier way for this scenario is to use DBJoin component instead of 2nd DBInputTable but it depends on the query you want to execute. To do it with DBInputTable, you need to transform the obtained string in Reformat component, to create a query, that can be sent to DBInputTable.