Interface tool for output tool updating

[chvizda]

Hi all

I'm have some problems to perform following workflow.

I have a teradata database and want to update these, based on the date in IR_TIMESTAMP and data in IR_ID and IR_NODE which I want to select via 3 Interface tools.

After selecting this, following update statement should performed with the red data from the interface tools.

UPDATE ADV_ANA_MRT.T_VIZDA_CS_KPI_1H
SET "IR_DAY_PERC_DOWN"='0',
"IR_DAY_PERC_UP"='100',
"IR_REFDOWN_String"='0',
"IR_HOUR_PERC_UP"='100',
"IR_HOUR_PERC_DOW"='0',
"IR_DAYCHNG"='0'
WHERE "IR_ID" like 'NOV001%' AND "IR_NODE"='\MI-P-PROGNOSIS'
AND CAST("IR_TIMESTAMP" AS DATE)='2021-11-14';

Is this possible ?

If yes, can you plese give some tips !

Many thanks

Steffen

[afv2688]

Hello @chvizda ,

Have you tried inserting the tools within a batch macro and replace the values in there? It might be the easiest way for you. Having a control parameter for each value would be probably the easiest solution.

Regards