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
Solved
Project Variables in
Best answer by Christian Hauggaard
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
+5Hi
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
