how to add single values into existing table

Mon, 17 Aug 2015 08:48:54 GMT

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!

topic how to add single values into existing table in QlikView

how to add single values into existing table