Hey all,
I build a quite simple inline table at the beginning of my load script. The process runs dynamically, but finally the table looks similar to this. For the column of "value_03" I don't define any value, but I already create the column as a placeholder.
| year | code | value_01 | value_02 | value_03 |
|---|
| 2014 | EUR | 1 | 1 | 1 |
| 2015 | EUR | 1 | 1 | 1 |
| 2014 | USD | 1,32 | 1,35 | |
| 2015 | USD | 1,11 | 1,25 | |
During next steps in my load script I have a loop where I switch between different years and/or codes. During each run I calculate different values for the column "value_03". So Now I would like to add those values especially into that one field, depending on the actual year of the run, the "code" and the column "value_03". In fact in first run of the loop I calculate data for the year 2014 and for USD for coulmn value_03, in second for year 2015 and so on ...
So how can I do this? I tried with stuff like Joins, but I don't need to add whole coulmns or rows. I just want to edit/add that single value per each run.
Would be so glad about any help! Thanks a lot!
BR
