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.
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 sqla batch macro input tool where you can use a pre or post sql to post free sql
Best regards,
Simon