Join by record position in Qlik Sense

[BlakeGri2093]

Hi guys

Does Qlik Sense Script Support to join 2 table based on record position (i try to use join statement but it seem doesn't work) . Anyone has solved this issue?, thank in advanced.

This is example and the output desired

Table 1

RowA

RowB

RowC

RowD

Table 2

Row1

Row2

Row3

Row4

The output desired:

Row A    Row1

Row B    Row2

Row C    Row3

Row D    Row4

[tresesco · Accepted solution]

You can introduce a new field with row number in both the fields and join on that key like:

[Table 1]:
Load *,
	RowNo() as KEY Inline [
Field1
RowA
RowB
RowC
RowD ];

JOIN

[Table 2]:
Load *,
	RowNo() as KEY Inline [
Field2
Row1
Row2
Row3
Row4 ];
Drop Field KEY;