Hello,
TimeXtender 20.10.40.64.
I have created a simple project variable that takes the environment name.
Our goal was to use the project variable in a transformation to say that if a hard coded table field = project variable then 1 else 0.
The issue is I cannot use this field in transformations without timextender failing on deploying the table.
In the dev environment I have tried sereral ways to achieve this. Custom field transformations where I try to use project variable in any way just results in the error “invalid column name “X”. Where X is whatever enviroment I try to deploy it on.
Is there any way to use environment project variables other then usage conditions on execution packages?
Thank you,
Victor
Page 1 / 1
Hi
Please try to use quotes around the project variable as shown below
This results in the following custom transformation
If you do not include quotes
Then it will interpret the environment name (i.e. Development) as a column rather than a string, hence the error message
This worked great, thank you for the quick help!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.