Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

Hi Neeraj,

Check the attached appliction.

Hope this helps you.

- Sridhar

View solution in original post

3 Replies
sridhar240784
Creator III
Creator III

Hi Neeraj,

Check the attached appliction.

Hope this helps you.

- Sridhar

jagannalla
Partner - Specialist III
Partner - Specialist III

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
Author

Hi Sridhar, Jagan

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

Thanks,

Neeraj