topic Re: Insert a row into table in QlikView

Insert a row into table

Fri, 08 Aug 2014 06:23:11 GMT

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?

Re: Insert a row into table

amit_saini — Fri, 08 Aug 2014 06:28:00 GMT

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

Re: Insert a row into table

maxgro — Fri, 08 Aug 2014 06:36:30 GMT

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

Re: Insert a row into table

er_mohit — Fri, 08 Aug 2014 06:44:31 GMT

load your existing qvd let say its abc.qvd

Table1:

load * from abc.qvd ;

concatenate(Table1)

load * inline [

Server Name

'<NA>'

];