dsanderbi commented on issue #5182: URL: https://github.com/apache/hop/issues/5182#issuecomment-3270649190
Hi @hansva, I tested whether I can use the variable resolver to read an SQL file and then use it directly in the Table Input step. <img width="432" height="239" alt="Image" src="https://github.com/user-attachments/assets/edb9d394-f0d7-4379-b1b6-44d097979e3e"; /> However, it turns out that if the content of the SQL — meaning the statement itself — contains another variable, that variable is not resolved in the Table Input step. The stream output <img width="804" height="145" alt="Image" src="https://github.com/user-attachments/assets/cc1f2ab0-f248-4382-9791-2c019352a8c4"; /> replacement_value should be TEST-TEST as defined here <img width="303" height="52" alt="Image" src="https://github.com/user-attachments/assets/17b3b6df-7498-4806-ad6e-4f332bf6e124"; /> **Therefore, the SQL statements that are externalized into SQL files must not contain any additional variables.** Is this behavior intended, or should the variable be replaced in the Table Input step after being resolved? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
