[Bug]: TABLE_INPUT transform will not accept rows from prior transformation

[dmainou]

Apache Hop version?

2.17

Java version?

jre-17-openjdk

Operating system

Linux

What happened?

Table input transform will not substitute the ? with the value coming from the prior transform.

I have tried all sorts of things including substituting the whole sql statement or just the dynamic value with no success.

2026/04/22 09:44:14 [Error]    r_SUBJECT_AREA.0 - Unexpected error
2026/04/22 09:44:14 [Error]    r_SUBJECT_AREA.0 - org.apache.hop.core.exception.HopDatabaseException: 
2026/04/22 09:44:14 [Error]    r_SUBJECT_AREA.0 - An error occurred executing SQL: 
2026/04/22 09:44:14 [Error]    r_SUBJECT_AREA.0 - ?
2026/04/22 09:44:14 [Error]    r_SUBJECT_AREA.0 - [SQLITE_ERROR] SQL error or missing database (near "?": syntax error)

026/04/22 09:51:53 [Basic]    failures_collector - Execution started for pipeline [failures_collector]
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - Unexpected error
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - org.apache.hop.core.exception.HopDatabaseException: 
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - An error occurred executing SQL: 
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - SELECT
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 -   subject_area
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , action
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , failed
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , api_url
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , api_body
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , fields
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , changes
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , response_status
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , response_time
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - , response_body
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - FROM ?
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - where failed = 1
2026/04/22 09:51:53 [Error]    r_SUBJECT_AREA.0 - [SQLITE_ERROR] SQL error or missing database (near "?": syntax error)

I believe I am correctly configuring the step (same as for the last decade lol)

Issue Priority

Priority: 3

Issue Component

Component: Hop Gui

[hansva]

From can't be replaced that way, was never possible. Prepared statements (?) only work for values not for objects. Table names can only be inserted using a variable

[dmainou]

Thanks Hans.
I fixed it by using a pipeline executor. Would be great if it could be replaced.

[hansva]

We can't, it's a prepared statement and that's one of the limitations of that concept