topic Re: qlikview in QlikView

qlikview

soumya_jindal — Fri, 05 Apr 2019 05:53:41 GMT

I have table

Load * inline [

name,count

A,1

b,2

c,3 ];

need output

a 1

b 1

c 1

How can be achieved

jyothish8807 — Fri, 05 Apr 2019 08:08:11 GMT

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;

tresB — Fri, 05 Apr 2019 08:13:30 GMT

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