topic How to insert rows on load? in QlikView

How to insert rows on load?

Thu, 11 Nov 2010 14:29:28 GMT

Hello,

As you can see in the attached application we are trying to add a new row to the orginal data containg a calculation between two orignal rows.

This example works but is not pretty, for large quantity of data you probably would like to do this in one load.

Is that possible?

Thanks in advance!

How to insert rows on load?

Thu, 11 Nov 2010 14:50:31 GMT

This is a tricky one.

How to insert rows on load?

johnw — Wed, 17 Nov 2010 20:07:27 GMT

My large loads are usually from QVDs. I want those loads to be optimized. Therefore, I wouldn't want to add the additional rows as part of the main load, even if it's possible. So my recommendation is just to streamline your three succeeding loads into one:

CONCATENATE (MainTable)
LOAD
'3.1' as Question
,sum(if(Question=4,Answer,if(Question=3,-Answer))) as Answer
,City
,Unit
RESIDENT MainTable
GROUP BY City, Unit
;

Technically you don't have to say concatenate since it's the same list of fields, but I always like to be explicit.

How to insert rows on load?

suniljain — Fri, 19 Nov 2010 10:05:14 GMT

just refer qlikview manual it contain logic for insert, update and delete of record in QVD.

How to insert rows on load?

Fri, 19 Nov 2010 22:42:51 GMT

thanx, nice short script.