Discussion Board for collaboration on QlikView Scripting.
I have a table with the server information . I need to add another row into this table for Server Name as '<NA>' and store it into the already existing QVD.
So if the table has 500 rows , the 501 st row or the 1st row should be the '<NA>' row.
This must be done in the load script. Can it be done?
Do like this:
Load DEPT, DESC, AMOUNT
from QvdData.qvd(qvd); //here provide your qvd name
MinString('RETENTION') as DESC,
Sum(if(DESC = 'INCOME', 1, if(DESC = 'PAYMENT', -1, 0)) * AMOUNT) as AMOUNT
Group By DEPT;
STORE Data into QvdDataUpdate.qvd;
load * from t.qvd (qvd);
'N/A' as [Server Name],
'AAAA' as field2,
1111 as field3
store t into t.qvd (qvd);
load your existing qvd let say its abc.qvd
load * from abc.qvd ;
load * inline [