Computing from 2 tables

[#1]

I have a 'Month' field and a 'Date' field in one load table and various values for each of the 12 months in another load table. I want to get the value from this table based on the 'Date' field

LOAD

...

Month,

Date

....

;

LOAD

...

Jan_value,

Feb_value,

...

;

I want to do something like

LOAD

if (Month = 1, Jan_value, if (Month = 2, Feb_value,....)

;

Can you suggest a way of doing this?

Thanks

[#2]

Hi Srikanth, First you need to join these  2 tables, after that you need to write IF cond in the Resident Load.

[Anonymous]

Try to rename the Jan value to Jan etc..

Then try to use the Crosstable wizzard, it will bring back your table from a matrix form to a simple form.

Then you could link the table via the new month field.

Have a look at this, might be of help for you

CrossTable.qvw