Solved

Project Variables in

  • 12 February 2024
  • 2 replies
  • 22 views

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

 
 

icon

Best answer by Christian Hauggaard 12 February 2024, 16:34

View original

2 replies

Userlevel 6
Badge +5

Hi @Victor 

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