Has anyone seen an issue with setting a local variable default with an environment variable?

Matillion ETL
1

The local variable default seems be getting set to the variable reference rather than the variable value.

Environment variable: a = "1"

Local variable b set equal to a using: ${a}

b gets set to ${a} and not "1"

2

Hello,

 

I am not too sure what your exact plans are but I have looked into similar before. I found that after a lot of trial and error I was unable to make a default of the variable the value of another variable. I imagine this could be done using Python, though I may need to brush up on my python skills first.

 

I have seen other users within this community explain a python scripting approach, so maybe they can help us both out!