Hi everyone!
I have a table with target values for HitRate for each store, month and year that I like to add to each date within the month.
TempHitrate:
| Year | Month | Shop | HitRate |
|---|
| 2014 | jan | 1006 | 6% |
| 2014 | feb | 1006 | 8% |
| 2014 | mar | 1006 | 5% |
| 2014 | apr | 1006 | 8% |
| 2014 | may | 1006 | 7% |
| 2014 | jun | 1006 | 8% |
| 2014 | jul | 1006 | 4% |
| 2014 | aug | 1006 | 7% |
| 2014 | sep | 1006 | 8% |
| 2014 | oct | 1006 | 9% |
| 2014 | nov | 1006 | 8% |
| 2014 | Dec | 1006 | 6% |
I'd like to create a table with new field, Date (generated in the same way as in QV calender-script), and add Shop and the value from the field HitRate in the table TempHitrate above so the result looks like this:
Hitrate:
| Date | Shop | HitRate |
|---|
| 2014-01-30 | 1006 | 6% |
| 2014-01-31 | 1006 | 6% |
| 2014-02-01 | 1006 | 8% |
| 2014-02-02 | 1006 | 8% |
So the field Date matches with the correct month and year in the first table, and adds the value for HitRate.
Is there anyone who know how to solve this I'm very greatfull!
Brg Johan
