Hello everyone !
I have a table A contains 1 column and 1 row and 1 value
This value changes every day
No linked to other tables on my FM
So, I have a table B
I need to add a new column contains this unique value for all rows of table B
Is it possible in Framework manager ?
Thanks a lot
Quote from: benji41 on 11 Feb 2015 04:50:45 AM
Hello everyone !
I have a table A contains 1 column and 1 row and 1 value
This value changes every day
No linked to other tables on my FM
So, I have a table B
I need to add a new column contains this unique value for all rows of table B
Is it possible in Framework manager ?
Thanks a lot
Hi,
Yes - you need to allow cross-joins though, or add a calculated item to each query subject and create a relationship based on this.
If you have both tables imported as separate query subjects, it's easy to add a calculation to each query subject - give it an expression of 1
Then create a relationship between the two query subjects, linking based on the new calculation in each.
In the tier above you can then create a new model query subject that contains all the required items from both.
Cheers!
MF.
Thx a lot !
In the end, I have create a parameter map and create an item based on the returned value