topic Re: use for loop while loading from a table in QlikView

use for loop while loading from a table

Mon, 15 Aug 2011 00:23:25 GMT

Hi All,

I have TABLE1, that has 3 fields : LETTER, WORD, LOOP

LETTER WORD LOOP

A Apple 2

B Ball 3

C Cat 1

What I am trying to generate is TABLE2 which looks like this:

LETTER WORD NEWFIELD

A Apple 2 Apple

B Ball 3 Ball

C Cat 1 Cat

ie. the rows should get duplicated based on the value of LOOP.

Thanks,

Neeraj

sridhar240784 — Mon, 15 Aug 2011 03:55:14 GMT

Hi Neeraj,

Check the attached appliction.

Hope this helps you.

- Sridhar

jagannalla — Mon, 15 Aug 2011 04:52:48 GMT

Try this..

Table1:

Load * Inline [

F1, F2

1, B

2, D

3, R

];

Table2:

Concatenate

LOAD F1,F2,RowNo() as Id

Resident Table1;

Mon, 15 Aug 2011 13:03:09 GMT

Hi Sridhar, Jagan

Thank you very much for your inputs. I was able to resolve my issue.

Thanks,

Neeraj