Insert value from stand alone table

[benji41]

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

[MFGF]

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.

[benji41]

Thx a lot !

In the end, I have create a parameter map and create an item based on the returned value