Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;