Dynamic table name in Output tool's Post Create SQL statement

[unat]

In the output tool a Teradata table (tblabc) is being created with a column value (LoadDate) as the suffix "Append Suffix to File/Table Name".

In the same output tool's "Post Create SQL statement" I would like to run collect statistics like so, but not sure how to mention the dynamic table name. How do I mention the suffix which is part of the dynamic t

Collect statistics on tblabc_&[LoadDate] column(col1)

gives an error :
Output Data (16) Executing PostSQL: "COLLECT STATS ON tblabc_&[LoadDate] column (col1);" : [Teradata][ODBC Teradata Driver][Teradata Database](-3706)Syntax error: expected something between the word 'tblabc_' and the end of the request.

[simonaubert_bd]

Hello,

I don't think it's possible. However you can use

-a block until done before your output data.

- on the second branch of your block until done :
1/a summarize to aggregate and get the table name (or get the date + a formula tool)

2/ then a dynamic input tool where you can use a pre or post sql to post free sql
a batch macro input tool where you can use a pre or post sql to post free sql
 
Best regards,

Simon