How to use variables in an update table join expression?

RAMI · October 4, 2022, 9:29am

Hi,

using the Table Update I'm trying to loop through multiple target tables and update the corersponding input tables based on different columns depending on the specific table being looped through.

I've added a column for the grid variable called updateTableJoin, which holds the value of the the tables unique column names (e.g. "no_"). which becomes the variable ${EQM_raw_updateTableJoin} (seen in screenshot).

When i write the join expression in the Table Update component:

"target".${EQM_raw_updateTableJoin} = "input".${EQM_raw_updateTableJoin} and run the job. I get an error saying:

"SQL compilation error: syntax error line 86 at position 56 unexpected '$'."

Which leaves me with the impression that the component cannot read variables in the join input?

Does anyone know how to use a variable in the join section of update table?

Thanks

Anne

(I've also tried writing the full statement in the variable)

Topic		Views
I am tryin to use a variable in the join condition of the target update component in Matillion. The value for the variable has already been set in the orchestration job. When i run the job the variable is not getting resolved Matillion ETL	5	January 26, 2022
I am using a variable in the join condition of the target update component in the matillion transformation job. But it does not get resolved during execution and hence the job fails during runtime Matillion ETL	1	April 26, 2021
I am using "Table Update" component for a GENERIC process to update the tables. I am using grid variables to store column names / primary key indicator for both source and target. I want to update the target table by comparing primary key dynamically Matillion ETL	2	April 13, 2022
SCD Table update join condition. I would like to use a grid variable here but can't so how can I get the join columns out of a grid variable and into this attribute via an environment variable? Matillion ETL	0	November 12, 2020
If seen that Matillion SQL Expression can containt what looks like references to table of the form `$T{logical_table_name}` Example: SELECT * FROM $T{Table Input} Matillion ETL	2	September 1, 2023

How to use variables in an update table join expression?

Related topics