topic How to auto generate on loaded data? in QlikView

How to auto generate on loaded data?

jagannalla — Wed, 15 Jun 2011 14:57:48 GMT

Hi,

- I have an excel sheet with columns ID,A,B and the number of rows is 3. Now i'll load this excel sheet into qlikview and assign a table name for this data.

- Now i want to autogenarate this table upto 100 rows on repeating A,B field data of 3 rows only and distinct value for ID.

For Example:

// This is excel sheet data

Table1:

ID A B

1 a1 b1

2 a2 b2

3 a3 b3

// I want generate this table upto 100

Table1:

ID A B

1 a1 b1

2 a2 b2

3 a3 b3

4 a1 b1

5 a2 b2

6 a3 b3

. . .

100 a3 b3

How to auto generate on loaded data?

brenner_martina — Wed, 15 Jun 2011 15:06:56 GMT

Hi, Jagannalla,

there is a function: RowNo(), you can enter in your script something like this:

Table1:

ID A B

1 a1 b1

2 a2 b2

3 a3 b3

For i=1 to 32

Concatenate (Table1)

Load

RowNo() As ID,

Resident Table1;

Next i

Concatenate (Table1)

Load

RowNo() As ID,

Resident Table1 Where A='a1';

I thing now you have 100 records.

Re: How to auto generate on loaded data?

johnw — Wed, 15 Jun 2011 23:33:34 GMT

LOAD ID+(iterno()-1)*3 as ID,A,B

INLINE [

ID,A,B

1,a1,b1

2,a2,b2

3,a3,b3

] WHILE iterno()<=33;

How to auto generate on loaded data?

jagannalla — Thu, 16 Jun 2011 05:45:40 GMT

Brenner / John

Thanks a lot it's working..

How to auto generate on loaded data?

jagannalla — Fri, 17 Jun 2011 12:40:59 GMT

John / Brenner

Is it possible to transfer a variable from one qvw file to another qvw file along with data after clicking the button.