Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Srikanth, First you need to join these 2 tables, after that you need to write IF cond in the Resident Load.
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