qlikview

[soumya_jindal]

I have table

Load * inline [

name,count

A,1

b,2

c,3 ];

need output

a 1

b 1

b 1

c 1

c 1

c 1

How can be achieved

[jyothish8807]

Hi Soumya,

Try this:

A:
Load * inline [

name,count

A,1

B,2

C,3
];

for i=0 to 2

let vNum= num(peek('count',$(i),'A'));
let vName= peek('name',$(i),'A');

Temp:

Load
'$(vName)' as New_name,
1 as New_count

AutoGenerate($(vNum));

Next i

Drop table A;

[tresesco]

A little simpler solution could be like:

Load 
	name&'1' as output
	while IterNo()<=count;
Load * inline [
name,count
A,1
b,2
c,3 ];