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.
