Skip to main content
Solved

Use Project Variable as Fixed value for join


v20.10.36.64

When setting up the relation between two tables, is there a way to use a project variable as the “Value” when the “Fixed Value” option is used?

Best answer by Søren Sørensen

@richardray 

I agree it would be a nice feature to have.

In the interim, I guess you could add an additional field to the table. The field would have a custom transformation, the project/instance variable. You would then have a field join instead of a fixed join. What do you think?

View original
Did this topic help you find an answer to your question?

6 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @richardray can you please describe the use case you are trying to achieve? Although project/instance variables cannot be added to joins, it is possible to add custom conditions to conditional lookups which are based on project/instance variables

 


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @richardray did the workaround resolve your issue? Please let me know the use case you are trying to achieve


  • Author
  • Starter
  • 4 replies
  • May 12, 2023
Christian Hauggaard wrote:

Hi @richardray did the workaround resolve your issue? Please let me know the use case you are trying to achieve

Hi @Christian Hauggaard , apologies for the delay in responding. 

My use case is that I have a project variable which I update during mock loads for a data migration project. One of the lookups uses a columnar join and a fixed join which is the mock load code. Rather than have a fixed value I was hoping to use the project variable.

Would the instance variable work in the same way?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@richardray yes the instance and project variables work the same way. The instance variable is for the new cloud-enabled version of TimeXtender (and only relates to an instance) and the project variable is for legacy versions of the application (e.g the version you are using 20.10.36 and relates to a project). Are you using ODX or Business Unit? 


Forum|alt.badge.img+1

@richardray 

I agree it would be a nice feature to have.

In the interim, I guess you could add an additional field to the table. The field would have a custom transformation, the project/instance variable. You would then have a field join instead of a fixed join. What do you think?


  • Author
  • Starter
  • 4 replies
  • May 23, 2023
Christian Hauggaard wrote:

Are you using ODX or Business Unit? 

 

Hi @Christian Hauggaard, we’re using Business Unit.

I think for now, I will use @Søren Sørensen’s suggestion as that will work perfectly.

Thanks to both of you 👍


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings