Insert a row into table

[#1]

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?

[amit_saini]

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

[maxgro]

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);

[er_mohit]

load your existing qvd let say its abc.qvd

Table1:

load * from abc.qvd ;

concatenate(Table1)

load * inline [

Server Name

'<NA>'

];