topic Re: append rows to a table inside a loop in QlikView

append rows to a table inside a loop

ali_hijazi — Wed, 23 Nov 2011 09:23:25 GMT

Hello

I got a table on which I have a loop over each record

during the loop i'm applying a certain condition on a field if the row matches the condition I want to add the row to a Table

can I use the concatenate(TableName)?

how can I create an empty table to append data to

lironbaram — Wed, 23 Nov 2011 09:59:03 GMT

hei

check this example

hope it helps you

sivaramr — Tue, 30 Jul 2019 10:15:43 GMT

Hi Lironbaram,

Can you please share the example in the body of the reply, because i am using Personnel edition and can't upload in my version to see your answer.

Thank you

swarnendu — Wed, 31 Jul 2019 05:49:10 GMT

Hi @sivaramr this the script ..

BaseData:

LOAD * INLINE [

Champ1, Champ2, Champ3, Champ4, RowNumber

A, 1, I, UN, 0

B, 1, J, UN, 1

C, 2, K, DEUX, 2

D, 1, L, DEUX, 3

E, 2, M, DUEX, 4

];

let counter = NoOfRows('BaseData');

for i=0 to $(counter)-1

Data:

load Champ1 AS c1,

Champ2 AS C2,

Champ3 AS C3,

Champ4 As C4

resident BaseData

where RowNumber =$(i) and Champ2=1;

next

---------------------------------------------------------------

And this is the UI:

sivaramr — Wed, 31 Jul 2019 07:32:31 GMT

swarnendu — Wed, 31 Jul 2019 07:59:55 GMT

@sivaramr Its my pleasure