Discussion Board for collaboration on QlikView Scripting.
I have a table that I want to upgrade one of its fields here (COST) :
load * inline[
I have a file that contains the 2016 data , my question is how can i load the table , saying if COST is 0 take COST from file .
field in file:
Go to Solution.
Perhaps something like this:
// Current File
load * inline
ID, COST, YEAR
ID, COST As COST1, YEAR
If(COST = 0 Or IsNull(COST), COST1, COST) As COST
DROP Table COST:
1. You need to load both tables into your datamodel. If you load tables in a row they will autoconcatenated (union);
2. Perform resident load from Result table and exclude unnecessary rows using where clause and peek() or previous() functions.
Hope this sheds lights to the solution.
Thanks a lot