Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
In my test model i want to update data (Source1) from data (Source2)
If there're some existing YearWeeks from Source2, system must update NomId and Sales for it and add new data (not existing YearWeeks)
My necessary result table:
YearWeek | NomId | Sales |
201501 | 45 | 34 |
201501 | 223 | 4 |
201502 | 63 | 44 |
201503 | 23 | 234 |
201504 | 87 | 424 |
201505 | 114 | 35 |
201506 | 22 | 66 |
This Load Script should do the trick for you:
This Load Script should do the trick for you:
Thanks so much