Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

Connect tables with Loop

Hi there. Can you help me to connect 2 tables with Loop row by row.

T1
A
B
C
D
E
F

T2
15
32
52
55
21
7

There is no keyword for 2 tables. I just want that row1 to row1, row2 to row2...

T1T2
A15
B32
C52
D55
E21
F7

I have too many rows. So I wll not use inline table.

Thank you.

Labels (1)
1 Solution

Accepted Solutions
Quy_Nguyen
Specialist
Specialist

Try this:

Data:

Load

RecNo() As No,

T1

From Table1;

Join

Load

RecNo() As No,

T2

From Table2;

Result Table will have No, T1, T2 fields. You can drop No field by command

View solution in original post

1 Reply
Quy_Nguyen
Specialist
Specialist

Try this:

Data:

Load

RecNo() As No,

T1

From Table1;

Join

Load

RecNo() As No,

T2

From Table2;

Result Table will have No, T1, T2 fields. You can drop No field by command