Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Anitha,
Do like this:
Data:
Load DEPT, DESC, AMOUNT
from QvdData.qvd(qvd); //here provide your qvd name
Concatenate(Data)
LOAD DEPT,
MinString('RETENTION') as DESC,
Sum(if(DESC = 'INCOME', 1, if(DESC = 'PAYMENT', -1, 0)) * AMOUNT) as AMOUNT
Resident Data
Group By DEPT;
STORE Data into QvdDataUpdate.qvd;
Thanks,
AS
t:
load * from t.qvd (qvd);
concatenate (t)
load
'N/A' as [Server Name],
'AAAA' as field2,
1111 as field3
AutoGenerate 1;
store t into t.qvd (qvd);
load your existing qvd let say its abc.qvd
Table1:
load * from abc.qvd ;
concatenate(Table1)
load * inline [
Server Name
'<NA>'
];