Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

use for loop while loading from a table

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

A               Apple        2 Apple

B               Ball           3 Ball

B               Ball           3 Ball

B               Ball           3 Ball

C               Cat           1 Cat

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

Thanks,

Neeraj

1 Solution

Accepted Solutions
sridhar240784
Contributor III

Re: use for loop while loading from a table

Hi Neeraj,

Check the attached appliction.

Hope this helps you.

- Sridhar

3 Replies
sridhar240784
Contributor III

Re: use for loop while loading from a table

Hi Neeraj,

Check the attached appliction.

Hope this helps you.

- Sridhar

jagannalla
Valued Contributor III

Re: use for loop while loading from a table

Try this..

Table1:

Load * Inline [

    F1, F2

    1, B

    2, D

    3, R

];

Table2:

Concatenate

LOAD F1,F2,RowNo() as Id

Resident Table1;

Not applicable

Re: use for loop while loading from a table

Hi Sridhar, Jagan

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

Thanks,

Neeraj

Community Browser