CODEWITHSUNDEEP
variablesdynamicoutputpentaho
Fuzzy
Fuzzy

Reputation: 3

Dynamic output table pentaho

In the ETL pentaho I would like to output my data in a dynamic "table output".

I am using the variable pil016_ext_wxxx which I entered in "table output" --> "target table"

I obtain an error as if he did not detect the data I input. (While it works if I just execute an SQL statement in the transformation with this variable)

2018/10/29 17:56:25 - pil016.pil016_ext_wxxx_temp 2.0 - The tablename is not defined (empty)

An image of my parameters inside table output

Do you know if it is possible to output data in a dynamic table in pentaho ?

Upvotes: 0

Views: 545

Answers (1)

AlainD
AlainD

Reputation: 6356

Your are looking for the Metadata Injection step, documented here.

Your case is covered by Diethard's tutorial (jump to the Metadata driven ETL section).

Upvotes: 1

Related Questions